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
Hello,
I think i'm trying to do something simple but I cannot find how.
I have data looking like this:
ID | Good1 | Good2 | Good3 | Bad1 | Bad2 | Bad3 |
1 | x | x | x | |||
2 | x | x | x | |||
3 | x | x | x | |||
4 | x | x | ||||
5 | x | x | x | |||
6 | x | x | x | |||
7 | x | x | ||||
8 | x | x | ||||
9 | x | x |
And I want to show it like that
Good1 | Good2 | Good3 | |
Bad1 | 1 | 1 | 1 |
Bad2 | 0 | 1 | 3 |
Bad3 | 2 | 2 | 1 |
Basicly, I want a CountIfs. How many poeple are Bad1 and Good1.
The complexity seams to come by the fact that they can have multiple Good and Bad.
Thanks in advance 🙂
Solved! Go to Solution.
trying to do something simple
ahaha. Good one. None of this is simple.
Here's a version that works but at a high cost - an atrocious data model
see attached.
Thanks you. That's what I wanted (I though it was simplier to do though 😅)
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 |
---|---|
111 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
153 | |
125 | |
114 | |
111 | |
95 |