## Desktop

Member
Posts: 140
Registered: ‎01-03-2017

# 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

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

## Re: Calculated Measure is duplicating information on a table visual

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```

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

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

## Re: Calculated Measure is duplicating information on a table visual

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```

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