cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

## DAX measure for combining text based on Slicers

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.

1 ACCEPTED SOLUTION
Community Support

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]))`

Regards,

Jimmy Tao

2 REPLIES 2
Community Support

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]))`

Regards,

Jimmy Tao

Anonymous
Not applicable

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.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors