MAX value of a measure on different aggregation levels

[Anonymous]

Dear Community,

I would like to work with the MAX of a measure value on different evaluation levels in a matrix table.

Evaluation level 1	Evaluation level 2	Value of measure AVERAGE
ID 1	ID 11	100
ID 1	ID 12	200

If I create a matrix table with "Evaluation level 1" in the row level, it will summarize the measure value:

Evaluation level 1	Value of measure AVERAGE
ID 1	300

How can I create a solution, where I can use the MAX value of my measure here?

Thank you for your support in advance!

[v-robertq-msft]

Hi, @Anonymous 

According to your description, I guess you want to replace the summarized value with the max value of the measure[AVERAGE] in the total row, and the measure[AVERAGE] calculates the average value of [data]. I think that you can try this measure:

AVERAGE = MAXX('Table',CALCULATE(AVERAGE('Table'[Data])))

And you can place this measure into the Matrix, you can get what you want, like this:

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[AlB · Accepted solution]

Hi @Anonymous 

I would need more details but try creating this new measure based on the one you have:

Measure =
MAXX ( DISTINCT ( Table1[Evaluation Level 2] ), [Value of measure AVERAGE] )

and place it in a table visual with Table1[Evaluation Level1] in the rows. Note [Value of measure AVERAGE] is the measure you currently have and are showing in the visuals.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

Hi @AlB 

it works great, thank you!