Forum Discussion
Anonymous
3 years agoNot applicable
DAX Measure error - to remove fixed values with table column fields
Hi Experts The following measure currently has fixed values i want to changes thes to table column fields. Current MEasure Measure 2 =
VAR _CountryStore = "(Cananda),(Italy);[004],[005]"
V...
- 3 years ago
You could try something like
Selected countries and stores = VAR _Countries = "( " & CONCATENATEX( VALUES( 'pg_control_cases'[country_dim.country_name] ), 'pg_control_cases'[country_dim.country_name], "," ) & " )" VAR _Stores = "( " & CONCATENATEX( VALUES( 'pg_control_cases'[bu_code] ), 'pg_control_cases'[bu_code], ", " ) & " )" RETURN _Countries & ";" & _Stores
johnt75
Super User
3 years agoI don't understand. You say that the country and store values are coming from separate columns, what is populating the slicer ?
Anonymous
3 years agoNot applicable
See attached sample file
i want measure 2 to be dynamic based on slicer selection
https://www.dropbox.com/s/vwarlltsrk7s5nq/Sample%20Data.pbix?dl=0