How to Make FY and LocationCode Slicers Dynamic Based on Selected Country in Power BI

Hi GanesaMoorthyGM 

I would not use bidirectional relationships as the risk of bad perfomance and ambiguity are always there. On the contrary, I would follow MasonMA  suggestion and create a measure to use as a filter.

On that, as this is a complex DAX topic, I just want to make it clear to you that, following suggestion from MasonMA, you will define the filters applied to the model before evaluationg the measure and check its value to be equal to 1. You will deinfe this filters by grouping columns in the visual.

If you group Country, Fiscal Year and Location, the visual will show only rows for which Country, Fiscal Year, Location provide a non empty Sales table.

So my post here is just a way to help you understading what a measure filter is, hope I helped clarifying what MasonMA is suggesting. I agree with his suggestion

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI