Reply
Highlighted
Member
Posts: 140
Registered: ‎01-03-2017
Accepted Solution

Calculated Measure is duplicating information on a table visual

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 Smiley Happy ).

 

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

 

Thanks


Accepted Solutions
Community Support Team
Posts: 7,714
Registered: ‎08-14-2016

Re: Calculated Measure is duplicating information on a table visual

Hi @rmachado,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post


All Replies
Community Support Team
Posts: 7,714
Registered: ‎08-14-2016

Re: Calculated Measure is duplicating information on a table visual

Hi @rmachado,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Member
Posts: 140
Registered: ‎01-03-2017

Re: Calculated Measure is duplicating information on a table visual

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. Smiley Happy