Use a measure as a filter

[Anno2019]

Hi Guru's

My origin post was https://community.powerbi.com/t5/Desktop/Calculated-Column-based-on-date-fields-to-show-Order-Status...

But I am now struggling with the second portion of the problem.

My Calculated Column which is a MEASURE returns text values Column Name [Shipment Status].

"Order not yet booked"

"Order Departed but not arrived"

etc etc

I need to use this calculated measure as a filter slicer, I would like to choose one of the returned values and see a lit of all orders which have that particular status in a table.

[v-diye-msft · Accepted solution]

Hi @Anno2019 

Sorry for my late reply on the previous case.

You can add another new table with only 1 column which list the status:

And then add the measure 2 :

Measure 2 = var a = SELECTEDVALUE(Table2[Column1])
Return
IF(a=BLANK(),[Measure],MAXX(FILTER(Table1,[Measure]=a),[Measure]))

Please note that make sure measure 2 is not blank.

The final result shown as:

Pbix attached here for your reference: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EcLQeVDdkAlEsYY-lrueqN...

Best regards,

Dina Ye

[Anno2019]

Perfect Perfect Perfect...it works!!!