Calculated Measure is duplicating information on a table visual

[Anonymous]

I created two Calculated Measures based on SUM that work perfectly in my case.

But when I used those to create a third one using the following formula it duplicated (ou triplicated) the data in my table.

The measure is:

Progress Deviation = ('public table1'[Actual Progress]/'public table1'[Calculated Progress]) -1

If I remove the '-1' the table is fine (but the value is wrong 🙂 ).

What can I do to solve this? I'm just subtrating a -1 to all values...

Thanks

[v-shex-msft · Accepted solution]

Hi @Anonymous,

You can try to use divide function to deal with this issue.

Measure = DIVIDE(MAX([Column1]),MAX([Column2]),0)-1


Calculate Column = DIVIDE([Column1],[Column2],0)-1

Reference link:

DIVIDE Function (DAX)

Regards,

Xiaoxin Sheng

[Anonymous]

Hello

Thanks for the help, but I ended up by using your suggestion with a SUMX

SUMX(TABLE,DIVIDE(MAX([Column1]),MAX([Column2]),0)-1) 

It worked. 🙂