Forum Discussion
Post ProdigyPercentage Row Total not working for 100% Stacked Column Chart
harirao
That's a basic method to calculate percentage, this might change depending on you logic. If you have issues using this, please share a sample file or logic along with column names.Perct=
Var overall = CALCULATE(sum(sales),all('Table'))
return DIVIDE(sum(sales),overall,0)
Don't forget to change the data type to percentage for this measure.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
Hi harirao ,
Thanks for NaveenGandhi reply.You can try measure below
Measure = VAR a = SUM('Table'[Value]) VAR b = CALCULATE( SUM('Table'[Value]), ALLEXCEPT( 'Table', 'Table'[Qtr] ) ) RETURN a/bFinal output
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Post ProdigyHi NaveenGandhi
As mentioned, I tried changing it to 2 decimal places. Please see the screen print below for your reference.
Could you please share a sample DAX measure for the "Percent Calculation"?
Thank you
Memorable Memberharirao
That's a basic method to calculate percentage, this might change depending on you logic. If you have issues using this, please share a sample file or logic along with column names.
Don't forget to change the data type to percentage for this measure.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!