Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi team,
I have written a DAX that will return a new table. The dax code will split the comma delimited column to rows and then have to filter the table based on the slicers selection criteria. Below code is giving the new table only when the manual input is given.If I do it dynamically from the Slicer selected value no results are showing.
The highlighted line is not working. and I wanted to filter the table by multivalues from the slicers.
I am attaching the sample pbix file.
Appreciate the help.
New table calculated from DAX:
Brand | Sub | Event | Tasks | Amount |
AA | Free | Group1 | a,b,c | 100 |
AA | Normal | Group2 | b,c | 150 |
AA | Free | Group3 | a,c | 200 |
BB | Normal | Group4 | b,d | 130 |
BB | Free | Group5 | a,c,d | 50 |
CC | Free | Group6 | d | 250 |
CC | Free | Group7 | c,d | 300 |
DD | Normal | Group1 | a,d | 100 |
Expected result based on the above dax:
Brand | Sub | Event | SingleValue | Amount |
AA | Free | Group1 | a | 100 |
Solved! Go to Solution.
For comma separated column, you can try the following solution, it will work better.
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
13 | |
12 | |
12 | |
9 |
User | Count |
---|---|
65 | |
20 | |
20 | |
17 | |
11 |