Forum Discussion

NT2510's avatar
NT2510
Frequent Visitor
5 years ago
Solved

Incorrect Measure Total

Hello, I am trying to figure out how to show correct totals in below table.  Denominator and Numerator are two different measures and Old_Ratio just calculates as Numerator/denominator. For Q2, the...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi NT2510 ,

    You can create another new measure as below to replace the measure [Ratio](Ratio=Divide(Numerator,Denominator)) and put it on the matrix. Please note that replace the table name "Table" referenced in the following formula with the actual table name you applied to the matrix.

     

    New Measure =
SUMX (
    GROUPBY ( 'Table', 'Table'[Year], 'Table'[Quarter], 'Table'[Month] ),
    [Ratio]
)

     

    If the above one can't help you get the correct result, you can refer the method in the following links to resolve it.

    Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

    Dax for Power BI: Fixing Incorrect Measure Totals

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi NT2510 ,

Whether your problem has been resolved?  If yes, please mark the helpful post as Answered? It will help the others find the solution easily if they face the same problem with you. Thank you.

Best Regards