Slicing by measure not affecting visual card

[RegionH]

I have a dataset of purchase order data. In the data I have a measure called 'Score class', which based on the suppliers delivery performance 'PO on time %' gives them a class from A+ to D. I then use that score class measure as a slicer. It works fine on a visual table, but it is not working on a visual card which shows the measure 'PO on time %'. The overall 'PO on time %' from all suppliers is still shown and not the filtered value.

Maybe someone could help me in the right direction to achieve want I want.

Link to pbix file: Measure as slicer.pbix 

[RegionH]

Thank you for the solution it works very well.

[v-zhangti · Accepted solution]

Hi, @RegionH 

You can try the following methods.

Measure = 
Var _table=SUMMARIZE(PO,PO[Supplier],PO[PO total],"Socre",[Score class],"Value",[PO on time])
Var _N1=SUMX(FILTER(_table,[Socre]=SELECTEDVALUE('Score Class'[Selection])),[Value])
Var _N2=SUMX(FILTER(_table,[Socre]=SELECTEDVALUE('Score Class'[Selection])),[PO total])
Return
DIVIDE(_N1,_N2)*100

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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