Computation per Unit

Hi Guys, Would need your help in computing the per unit computation. I have year my monthly table. The computation of PER UNIT is Data Point per Month / Maximum Data Point. Ex. 456/999 to get 0....

Need Help

Anonymous
4 years ago
Hi icdns ,

Please refer to my pbix file to see fi it helps you.

Create a measure or column.

Measure = VAR max_value = CALCULATE ( MAX ( sampledata[Sales] ), ALLEXCEPT ( sampledata, sampledata[Year] ) ) RETURN DIVIDE ( MAX ( sampledata[Sales] ), max_value )

The column.

Column = VAR max_value = MAX ( sampledata[Sales] ) RETURN DIVIDE ( sampledata[Sales], max_value )

If I have misunderstood your meaning, please provide your desired output with more details.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sample powerbi.pbix111 KB

VahidDM

Super User

4 years ago

HI icdns

You need to calculate the MAX when you removed the filter to consider all rows' values.

Try this to find 999:

MAX Value = calculate(MAX(Table[Count]),all(table))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/