Retrieve Max of Measure (PBI example file included)

[HR30385]

Hi, 

I need to retrieve the max value for my measure (revenue_cost_ratio) depending on what is shown in my table. The filter context must be used to retrieve the max value. Here is the example:

Here my max measure for revenue_cost_ratio should return 239%:

When filtered for "Summer" my max measure should return 184%:

Here is the power bi file: https://easyupload.io/w2824z

Any help is greatly appreciated!

[ThxAlot · Accepted solution]

Max revenue_cost_ratio = 
MAXX(
    SUMMARIZE( fact_sales, dim_manufacturer[Manufacturer], dim_category[category] ),
    [revenue_cost_ratio]
)

[Selva-Salimi]

Hi @HR30385 

you can write a measure as follows:

measure max_percent := var tbl1= summarize (table, [category], [manufacturer] ,'rev' ,[(revenue_cost_ratio])

return maxx(tbl1, rev)

If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly.