Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi guys,
I have a customer count table as per below:
Customer Count = the count of customer with the attribute on the right.
Use 1st row for instance, there is 1 customer with Mutual Fund ONLY (Mutual = Y, GIC & CASH = N).
I am looking for a way to create a slicer that looks like this
With Mutual Fund |
With GIC |
With Cash |
Thus, if I select With Mutual Fund , I will get customer count = 1+1+2+3+4+5 = 16 (all the rows with mutual fund = Y)
Lastly, if I multi-select With Mutual Fund & With GIC, I will get customer count = 1+2+3+4+5 = 15 (all the rows with mutual fund = Y AND with GIC = Y).
Any idea is much appreciated!
Thank you
Solved! Go to Solution.
Hi @ljx0648
To get the desired result :
You need to unpivot the table from PQ :
At this stage you can create simple dax measure :
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @ljx0648
To get the desired result :
You need to unpivot the table from PQ :
At this stage you can create simple dax measure :
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi Ritaf,
Thank you for your idea. Your idea works as listed!
Happy to help 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |