Forum Discussion
Helper IVMatrix Percentage Measure values on Rows Month, Quarter don't add up accurately
I have a Matrix table with Measures showing on rows. When I drill-down the date heirarchy the % Totals do not add for the percentage change. The measure sample below for the Total GP - Goal %. Is there a way to accuratly Total % by Month, Quarter, Year accuratly?
Fro88er , This should not add, this should recalculate and looking at number this is correct to
Total GP - Goal % =
DIVIDE([Total GP - Goal Var], [Total GP Marketing])or try like
sumx(summarize(table, table[Year], Table[Qtr], Table[Month], "_1" ,DIVIDE([Total GP - Goal Var], [Total GP Marketing])),[_1])
check this too
2 Replies
- amitchandak
Super User
Fro88er , This should not add, this should recalculate and looking at number this is correct to
Total GP - Goal % =
DIVIDE([Total GP - Goal Var], [Total GP Marketing])or try like
sumx(summarize(table, table[Year], Table[Qtr], Table[Month], "_1" ,DIVIDE([Total GP - Goal Var], [Total GP Marketing])),[_1])
check this too
Fro88erYou are amazing thank you! Worked perfectly.