Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Trying to find a way to change a ratio calculation with slicer which is having values from a column.
For example: i have 3 values in a column: apples, pears, oranges and another column where i found which from these fruits are eaten or not, flaged with 1/0.
I want a slicer to select the fruit and get the ratio of that eaten fruit out of total. Total ratio of eaten apples is calculated like this: Total number of eaten apples / Total number of apples. From the slicer i want to change this calculation dynamically for each fruit.
Solved! Go to Solution.
try this in measure,
Ratio of eaten fruit =
VAR _eaten =
CALCULATE ( COUNT ( Table[Fruits] ), Table[Flag] = 1 )
VAR _all =
CALCULATE ( COUNT ( Table[Fruits] ), ALL ( Table) )
VAR _result =
DIVIDE ( _eaten, _all )
RETURN
_result
Thanks,
Arul
@Arul
Sure, but i have to show you the real data tables i use:
@Arul I've debug a little, and the _all variable doesn't work as intended, it should filter by the slicer value, i've got 1M results for it and the result doesn't change from the slicer , should be 5857
I've done it. I change _all variable with "
try this in measure,
Ratio of eaten fruit =
VAR _eaten =
CALCULATE ( COUNT ( Table[Fruits] ), Table[Flag] = 1 )
VAR _all =
CALCULATE ( COUNT ( Table[Fruits] ), ALL ( Table) )
VAR _result =
DIVIDE ( _eaten, _all )
RETURN
_result
Thanks,
Arul
User | Count |
---|---|
84 | |
72 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |