Highest (MAX) value of a measure over different categories

[richard_jackson]

Hi there!

I have a fact table containing "Value" and "Category" which is (many->one) related to a dimension table of "Category".

From those two tables I can create visuals for "Value" by "Category"

i.e. using a "Matrix" visual, with Rows="Category" and Values="Value" I get the following:

Category	Value
Apples	3
Bananas	7
Cabbage	5
Total	15

I would like to create a measure which would give me the highest value of an individual category - in the above instance it would return 7 as that is the single highest category value.

I've been able to create measures which give me the _overall total_ (in the above example this would give 15) but I can't work out how to give me the highest value over all categories.

How can I do this?

TIA!

Rich

[richard_jackson · Accepted solution]

Solved / Duplicate: https://community.powerbi.com/t5/Desktop/using-MAX-to-identify-the-max-value-calculated-by-a-measure...

In the above instance it would be:

MaxTest = MAXX(VALUES('DimensionTableName'[Category]),[NameOfMeasureWhichSumsTheValues])