Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 :) ).

 

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

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      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. :)