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

parry2k's avatar
parry2k
Super User
5 years ago

NT2510 change it to this

 

Ratio = SUMX(Values(Year), Divide(CALCULATE(SUM(Numerator)),CALCULATE(SUM(Denominator))))

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • NT2510's avatar
    NT2510
    Frequent Visitor
    5 years ago

    It wont work because numerator and denominator are measures and not the columns from the table.