dynamic concatenation of fields based on user selection

[Anonymous]

Hi all

i have data like below table 

Field 1	Field 2	Field 3	Field 4	Field 5	Field 6
ab	ba	ca	da	ea	fa
ab	ba	ca	da	ea	kk
ac	bb	cb	db	eb	fb
ad	bc	cc	dc	ec	fc

I want to create dynamic concatenation based on dimension selection filter 

EX 1:

I have selected "Field 1", "Field 2", "Field 3" in Dimensions selection filter & i have selected "Field 6" in Measure selection filter, so I want to concatenate three fields ( "Field 1" + "Field 2" + "Field 3") & based on this concatenation I want to show count distinct "Field 6" value 

Expected output:

EX 2:

I have selected "Field 2", "Field 4" in Dimensions selection filter & I have selected "Field 5" in Measure selection filter, so I want to concatenate two fields ( "Field 2" + "Field 4") & based on this concatenation I want to show count distinct "Field 5" value 

Expected output:

[v-danhe-msft]

Hi @Anonymous ,

Based on my research, I am afraid you could not to use multiple columns as slicer in Power BI and also could not use measure in slicer too.

Regards,

Daniel He

[Anonymous]

Hi  v-danhe-msft

below URL has "dynamic Measure" and "dynamic dimenstion" based on user selection, but I want to create "dynamic concatenation" based on user selection. is it possible?

http://www.leanx.eu/tutorials/dynamic-dimensions-in-power-bi