Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure ignore applied filter

hey expert i created a measure and dropped in table .From slicer i selected a specific region but still it shows data for all regions. As in below image its showing for all regions.. I want f...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

First of all, the filter will take effect when the related fields of different tables have created relationships, so you may need to create relationships between the related tables with "Both" of Cross filter direction. see more about relationship :Create and manage relationships in Power BI Desktop.

 

Secondly, you may change your measure formula using ALLSELECTED function instead of ALL function.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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