Forum Discussion
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]"
VAR SeparatorPosition =
SEARCH ( ";", _CountryStore )
VAR _Length =
LEN ( _CountryStore )
VAR _Country =
LEFT ( _CountryStore, SeparatorPosition - 1 )
VAR _Store =
MID ( _CountryStore, SeparatorPosition + 1, _Length - SeparatorPosition )
RETURN
CONCATENATE ( _Country, CONCATENATE ( ";", _Store))
I want to replace
VAR _CountryStore = "(Cananda),(Italy);[004],[005]"
With pg_control[Country] where teh above is(Cananda),(Italy)
ps_control[store] where[004],[005]
as opposited to fixed values in the variable
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
10 Replies
Why do you need to split them if they are already in separate columns ?
You can use SELECTEDVALUE
VAR _Country = SELECTEDVALUE('pg_control'[Country]) VAR _Store = SELECTEDVALUE('ps_control'[store])
yes..hold on uploading a sample file
I want the measure to change dynamically based on slicer selected - se measure 2 in the sample
https://www.dropbox.com/s/vwarlltsrk7s5nq/Sample%20Data.pbix?dl=0You 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