Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Perfect Perfect Perfect...it works!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |