Multiply all rows of one column with the Max Value of another Column

[Anonymous]

Hello,

I have a few columns in a report. I want to take the maximum value from one column ( it is a unique count of pages) and then multiply all rows of another columns with that number. What is the best way to do so?

Many Thanks

Roberto

[Anonymous]

Thank You. This works. I found the same solution in a video on YouTube. 

[Migasuke · Accepted solution]

Hi @Anonymous ,

If you want to use your "absolute maximum", you need to combine function like MAXX with ALL.

I can show you simple example:
In my case I have a column with some values and I want to get the maximum across all countries. My measure then looks like this:

You can then use this "MAX for ALL" to multiple another column or another measure for desired outcome.