Cascading Filters in Power BI

[Chari]

Hi all............

I want to Do Cascading Filters in Slicers.
i have total 9 filters. out of 9 filters 3 filters coming form one dim table. 2 filters from another dim table.another 2 filters from another dim table and another 2 filter are summarize columns.
Finally those 9 filters are coming from different table.So i wrote the dax like below. 
filter = INT(not isempty('WorkdayReward')|| not isempty('PeopleHRReward'))
WorkdayReward & PeopleHRReward these are the my fact tables. 

with the above dax Cascading is working, but if the filters are coming from same table it is working.

Please help me.....😊

[MFelix]

Hi @Chari ,

For this you need to create a bidirectionality on your filters, so the calculation must include a CROSSFILTER expression that allows for you to get the values filter from one filter to the other.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.