Solved: Re: Display/ Calculate Inverse Percentage

Rdarshana · ‎07-24-2024

Hi,
I have a requirement to display a field value as % percentage. However, this has to be inverse percentage.
For example, the field contains values such as 0.73, 0.82, 0.91, etc.

The new value should be : 1-0.73 = 0.27 = 27%, 18%, and 9% and so on.

Can this be done through DAX or any other calc?

RossEdwards · ‎07-24-2024

Yes a DAX measure is all you need. How you write it will come down to what you need to reference. Lets assume its a field that you want the inverse of:

Inverse Measure = 1 - SUM('YourTable'[YourField])

The above assumes you are just putting a field inside a table visual and letting all of the context do what needs to be done. Putting this measure in the table should have the same results.

It doens't have to be a SUM, it could be A

View solution in original post

RossEdwards · ‎07-24-2024

Yes a DAX measure is all you need. How you write it will come down to what you need to reference. Lets assume its a field that you want the inverse of:

Inverse Measure = 1 - SUM('YourTable'[YourField])

The above assumes you are just putting a field inside a table visual and letting all of the context do what needs to be done. Putting this measure in the table should have the same results.

It doens't have to be a SUM, it could be A