What is the best way to show a measure as a column in a table visual?

Deanna Gould 0 Reputation points
2023-08-30T18:10:43.21+00:00

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

User's image

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]))
Microsoft Managed Desktop
Microsoft Managed Desktop
A cloud-based service that brings together Microsoft 365 Enterprise and adds these features: User device deployment; IT service management and operations; and Security monitoring and response.
47 questions
0 comments No comments
{count} votes