Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have the following ProductTable with the column Status:
Status |
Done |
Ongoing |
Ongoing |
Done |
Ongoing |
Done |
Done |
Done |
Delayed |
Delayed |
I'm trying to create a card visualiation for each status (Done, Ongoing, Delayed) to show % of total. I have created three measures, this one is for Done (the others is simply a copy paste using Ongoing and Delayed instead):
However when I select for example "Done" in the slicer, the others should be 0% to avoid confusion. How can I make this happen?
Solved! Go to Solution.
@carlenb Was getting weird results with CALCULATE but this No CALCULATE approach works just fine.
Var_DonePercentage 1 =
DIVIDE(
COUNTROWS(
FILTER('ProductTable', [Status] = "Done")
),
COUNTROWS(ProductTable)
) + 0
Hi everyone! I am having a similar issue. I made the following measures to get the volume share of each category in a specific brand in my dataset. The two top measures are working properly, with the category measure filtering properly when selected. However, when I combine the two measures to divide it the ALLSELECTED measure stops working. What am I doing wrong?
Total for Category =
CALCULATE (SUM('DATA'[Volume]), 'DATA'[Brand] = "ABC", ALLSELECTED('CategoryTable'[Category]))
Total for Brand =
CALCULATE (SUM('DATA'[CY Reforecast]), 'DATA'[Brand] = "ABC")
Total for Category divided by Total for Brand =
DIVIDE([Total for Category], [Total for Brand])
Thanks!
@carlenb Was getting weird results with CALCULATE but this No CALCULATE approach works just fine.
Var_DonePercentage 1 =
DIVIDE(
COUNTROWS(
FILTER('ProductTable', [Status] = "Done")
),
COUNTROWS(ProductTable)
) + 0
@Greg_Deckler genius! Thanks Greg, got it to work. This week suddently looks brighter 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
50 | |
47 | |
16 | |
13 |