Hi,
I created a measure to calculate sell-through by Section, and I was hoping to show all of the sections with their corresponding sell-through. This measure works properly in the visual when I select a section with the slicer because I used the ALLSELECTED() function in my logic, seen below:
![User's image](https://learn-attachment.microsoft.com/api/attachments/175190bd-7670-462a-addc-c9844f3ba939?platform=QnA)
![User's image](https://learn-attachment.microsoft.com/api/attachments/07529fd9-7635-4aaf-9d8a-314a62ef3783?platform=QnA)
Quantity Sold by Section = CALCULATE([Quantity Sold], ALLSELECTED(xyz[section], xyz[Event Name]))
Quantity Unsold by Section = CALCULATE([Quantity Unsold], ALLSELECTED(xyz[section], xyz[Event Name]))
Sell-Through by Section = ([Quantity Sold by Section] / ([Quantity Unsold by Section] + [Quantity Sold by Section]))