Forum Discussion

maxs3's avatar
maxs3
Frequent Visitor
5 years ago
Solved

Create Measure to find multiple MAX based on three unique identifiers

Hello,   I am trying to find the MAX(Items) based on unique identifiers of Number, Group, and Divider   Number has multiple Groups (one to many) Group has multiple Dividers (one to many).   Re...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  maxs3 ,

     

    Create a measure as below:

    Measure = 
var _maxitems=CALCULATE(MAX('Table'[Items]),FILTER(ALL('Table'),'Table'[Number]=MAX('Table'[Number])&&'Table'[Group]=MAX('Table'[Group])&&'Table'[Divider]=MAX('Table'[Divider])))
Return
IF(MAX('Table'[Items])=_maxitems,MAX('Table'[Items]),BLANK())

    Put the measure in filter pane>choose measure is not blank.

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  maxs3 ,

 

Create a measure as below:

Measure = 
var _maxitems=CALCULATE(MAX('Table'[Items]),FILTER(ALL('Table'),'Table'[Number]=MAX('Table'[Number])&&'Table'[Group]=MAX('Table'[Group])&&'Table'[Divider]=MAX('Table'[Divider])))
Return
IF(MAX('Table'[Items])=_maxitems,MAX('Table'[Items]),BLANK())

Put the measure in filter pane>choose measure is not blank.

And you will see:

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!