Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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