filter non aggregate data using dax
1 Topic
Dax formula to filter table
Hi, I have text data visualised in a table in Powe bi. European Union is also available in data as a country. Requirement is to custom filter table in a way that if user select any EU country from slicer, table should show selected country + EU. In case non-EU country is selected, table should only show selected country. I have created a new table, not related to data model with list of countries and created below measure: Filter=If(selectedvalue(fact_table[country])="European Union"||Selectedvalue(facr_table[country] in values(unrelated_table[country]),1,0) I have applied this measure as visual filter to table visualisation and set it's value to 1. It's partially working and showing European Union when I select an EU country or non-EU country from slicer. Kindly help me to modify this calculation so it only shows European Union when an EU country is selected.Solved1.4KViews0likes7Comments