Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have a table that looks like the attached image. I also have a slicer filter with the selectables "Division, Department and Team"
Basically when one of these selectables is selected I want to build a measure that will do a distinct count of ClientKey for whatever was selected. So for example, if Division was selected then it would show Eng as having 5 distinct clients, Sco having 2. If Team was selected it would show North having 2 distinct client and South having 5. If department was selected it would show General as having 7.
Does this make sense?
Thanks for any help
Solved! Go to Solution.
Perhaps something along these lines:
Distince Count = IF( HASONEVALUE('#Choices'[Choice]), SWITCH( VALUES('#Choices'[Choice]), "Division", COUNTROWS(SUMMARIZE('#AATable','#AATable'[Division],'#AATable'[ClientKey])), "Department", COUNTROWS(SUMMARIZE('#AATable','#AATable'[Department],'#AATable'[ClientKey])), "Team", COUNTROWS(SUMMARIZE('#AATable','#AATable'[Team],'#AATable'[ClientKey])) ), COUNTROWS(SUMMARIZE('#AATable','#AATable'[Division],'#AATable'[ClientKey])) )
Perhaps something along these lines:
Distince Count = IF( HASONEVALUE('#Choices'[Choice]), SWITCH( VALUES('#Choices'[Choice]), "Division", COUNTROWS(SUMMARIZE('#AATable','#AATable'[Division],'#AATable'[ClientKey])), "Department", COUNTROWS(SUMMARIZE('#AATable','#AATable'[Department],'#AATable'[ClientKey])), "Team", COUNTROWS(SUMMARIZE('#AATable','#AATable'[Team],'#AATable'[ClientKey])) ), COUNTROWS(SUMMARIZE('#AATable','#AATable'[Division],'#AATable'[ClientKey])) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |