Forum Discussion
Stacked column graph not showing accurate % tooltip when sorted
I have a stacked column graph with a tooltip that shows the % of the value compared to the total. This is created by a measure. In the graph you can see that the proportion of the pink is 0.78 (78%) ...
Try update formula
% MEASURE 2 = DIVIDE(SUM('table1[Assign 1 to each number for count]), CALCULATE(SUM(‘table1'[Assign 1 to each number for count]),ALL(‘table1’)),0)
FarhanAhmed
Community Champion
Community ChampionCan you please share the sample data and dax of the measure that you are referencing.
Sure.
Below is the sample data:
The measure for % calculation for tooltip:
% MEASURE 2 =
DIVIDE(SUM('table1[Assign 1 to each number for count]),
CALCULATE(SUM(‘table1'[Assign 1 to each number for count]),ALL(‘table1’[overalloutcome 2])),0)
The table I created to order the graph:
- FarhanAhmed
Try update formula
% MEASURE 2 = DIVIDE(SUM('table1[Assign 1 to each number for count]), CALCULATE(SUM(‘table1'[Assign 1 to each number for count]),ALL(‘table1’)),0)Yes this worked, thank you very much!