Forum Discussion
Solved
Percentage value mismatch between Table value and Line and Clustered Column Chart value
Hi everyone, I'm facing a mismatch between values due my calculation DAX formula. I have a dataset below and I need to count the subjects by fiscal month and return a percentage of this subjec...
Ito_c , as per your given data I have created % Eva Measure based on Fiscal Month.
% Eva =VAR a_ = CALCULATE(COUNT(Table1[Fiscal_Month]))VAR b_ = CALCULATE(COUNT(Table1[Fiscal_Month]),ALLEXCEPT('Table1',Table1[Fiscal_Month]))RETURN DIVIDE(a_,b_)Then use this on Stacked Column chart so getting the correct result.
Tahreem24
Super User
Super UserIto_c , as per your given data I have created % Eva Measure based on Fiscal Month.
% Eva =
VAR a_ = CALCULATE(COUNT(Table1[Fiscal_Month]))
VAR b_ = CALCULATE(COUNT(Table1[Fiscal_Month]),ALLEXCEPT('Table1',Table1[Fiscal_Month]))
RETURN DIVIDE(a_,b_)
Then use this on Stacked Column chart so getting the correct result.
