DAX measure for combining text based on Slicers

[Anonymous]

Hi everybody, 

I'm looking for help regarding DAX measure for combinevalues or concatenate text, based on slicer.

I wrote this measure that works well, for one of the criterias, but for others not really. 

Measure = IF(ISFILTERED(tst[Race]), COMBINEVALUES(" ", "There are", SUM(tst[num]), SELECTEDVALUE(tst[Race]), SELECTEDVALUE(tst[Profession])), SUM(tst[num]))

In the first picture, it works fine, as I have selected just a race. As soon as I selected to races, it doesnt display the races of the profession (2nd photo). I would like it to show, there are 5 caucasian and asian teacher. Any idea guys why my measure is not working properly? I truly appreciate your help. 

[v-yuta-msft · Accepted solution]

Hi edoyak,

Modify your DAX formula like this:

Measure = IF(ISFILTERED(tst[Race]), COMBINEVALUES(" ", "There are", SUM(tst[num]), CONCATENATEX(tst, CALCULATE(MIN(tst[Race]), ALLSELECTED(tst[Race])), " and "), SELECTEDVALUE(tst[Profession])), SUM(tst[num]))

PBIX here: https://www.dropbox.com/s/djzm6i4jcjk19uh/DAX%20measure%20for%20combining%20text%20based%20on%20Slic...

Regards,

Jimmy Tao

[Anonymous]

I tried your solution and it works. thank you. But before this, I used Variables and it worked perfectly well for my situation because I had a lot more slicers and nested if's would've been a pain in the a**. Thanks a lot. I would refer to this solution in the future.