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.
Hello,
I have a table looking as follows:
Country Item
France Widget
France Widget
France Stone
Belgium Widget
Belgium Widget
What I try to do, is to create a measure that I can filter per country, so that it calculates the number of distinct items (widget or stones) as ratio of the total number of distinct items in the table.
In other words, when I filter on France the result should be 1 (France has 2 distinct items, widget and stone, and the total distinct items in the column are widget and stone), and when I filter on Belgium the result should be 0,5.
Any ideas on how to do this?
Many thanks!
Mark
Solved! Go to Solution.
Item Ratio = VAR NumItems = DISTINCTCOUNT([Item]) VAR NumAllItems = CALCULATE(DISTINCTCOUNT([Item]),ALL(WidgetsNStones)) RETURN NumItems/NumAllItems
Item Ratio = VAR NumItems = DISTINCTCOUNT([Item]) VAR NumAllItems = CALCULATE(DISTINCTCOUNT([Item]),ALL(WidgetsNStones)) RETURN NumItems/NumAllItems
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |