Forum Discussion

Mal_Sondh's avatar
Mal_Sondh
Icon for Helper II rankHelper II
5 years ago
Solved

Maximum Flag/Value over 2 columns

Hi,   If i wanted to create a filter for a chart and only wanted to include the Max Versions per Month end, how can i do this - example data as follows   Snap Key Snap Date Month End Versio...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Mal_Sondh 

    You can create a measure and then put the measure in the filter .

    max version =

    var max_version=CALCULATE(MAX('Table'[Version]),ALLEXCEPT('Table','Table'[Month End]))

    return IF(SELECTEDVALUE('Table'[Version])=max_version,1,0)

    Then put the measure in the filter ,set the value is equal to 1 ,

    The effect is as shown :

    I have attached my pbix file ,you can refer to it .

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Mal_Sondh 

You can create a measure and then put the measure in the filter .

max version =

var max_version=CALCULATE(MAX('Table'[Version]),ALLEXCEPT('Table','Table'[Month End]))

return IF(SELECTEDVALUE('Table'[Version])=max_version,1,0)

Then put the measure in the filter ,set the value is equal to 1 ,

The effect is as shown :

I have attached my pbix file ,you can refer to it .

 

Best Regards

Community Support Team _ Ailsa Tao

 

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