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.
Hello all,
I wonder if any of you could give some tips how can I solve the following:
In my sales table I have 3 team leaders , because of each phase of the sale process , lets call it Phase A, B and C , and some team leaders could have menbers in more than one phase.
I would like to have in one report the 3 phases and a unique filter that could filter all the reports correctly , any idea how can I create a filter that will combine this 3 team leaders fields ?
TL_A & TL_B & TL_C -----Unique Filter---------> Team leader
Thanks a lot for your inputs !
Paulo
Hi! @pmargari
Try using a dax function union. It will help you combine your leads.
https://docs.microsoft.com/en-us/dax/union-function-dax
Hello Ankit
Thanks for your reaply , but this fields are in the same table ....
KR
Paulo
Hi! @pmargari
Can you please share some sample data and your expected result?
User | Count |
---|---|
88 | |
88 | |
74 | |
68 | |
57 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |