topic Multiply all rows of one column with the Max Value of another Column in DAX Commands and Tips

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

Anonymous — Wed, 25 Jan 2023 15:51:02 GMT

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

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

Migasuke — Wed, 25 Jan 2023 15:59:32 GMT

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.

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

Anonymous — Tue, 31 Jan 2023 08:44:08 GMT

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