Forum Discussion
Helper ISlicing by measure not affecting visual card
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
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)*100Is 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.
2 Replies
RegionHThank you for the solution it works very well.
- v-zhangti
Community Support
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)*100Is 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.