Table Visual Conditional Filtering

[newpbiuser01]

Hello,

I have a table visual that I'd like to filter based on the max value in a column - so as an example, in the table visual below, I'd like to only include the rows where the FY-FQ = max(FY-FQ). 

Before:

Country	Currency	FY-FQ
US	USD	2021-1
Canada	CAD	2022-2
UK	GBP	2022-1
Australia	AUD	2020-0

After:

Country	Currency	FY-FQ
Canada	CAD	2022-2

Would anyone know how to do this in Power BI? I'd really appreciate any help!

Thank you!

[ribisht17 · Accepted solution]

@newpbiuser01 

Step - 0

NOTE: >> Duplicate your Date Column so that one column can be used to Split

Step 1

Split FY-FQ by delimiter

Step-2

Step - 3

Combine both the splits as below

COMBINE = CONCATENATE(Sheet1[FY-FQ.1],Sheet1[FY-FQ.2])

Step - 4

Filter = if( CALCULATE(MAX(Sheet1[COMBINE]),ALL(Sheet1))=MAX(Sheet1[COMBINE]),1,0)

Filter Step - 4 as 1

FINAL OUTPUT

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users