measure filter slicer

[erhan_79]

Hi there ;

in attached pbix i created a calculaed measure which is calling status .It gives the order number statu "Close" or "Open" , i wan to filter with filter slicer open and close orders on the table but because of to be measure i can not filter statu measure.

Also i want to create a stacked column chart and want to show quantities about closed orders and open orders etc. 

How can i manage them could you help pls ? 

thank in advance , you can find shared already pbix file below 

[Mikelytics · Accepted solution]

Hi @erhan_79 

Using measures as filter lead is not really working. Did you try to calulcate the status in a calulcated column. Calulcated columns are better to be used as filters as well as in visuals as cluster criteria and bring more usability from my experience. 

Best regards

Mikelytics

------------------------------------------------------------------------------------------------------------------------------

Did I solve your request?. Please mark my post as solution.

Appreciate your Kudos.

[mwegener]

Hi @erhan_79 ,

so that you can filter by status, it must be a calculated column and not a measure.