Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to make an weighted average. As can be seen in these PBIX: https://ufile.io/a0yzr I have a score of 67% because of that the person that is good (which means you're in the group '5-6') is twice in the data because of that he is in 2 departments; the other person is in 1 department. So the % is good.
But when I make a donutchart it becomes 50/50 because of that both clients count as 1. I can imagine that this behaviour is good, but now I don't want this; I want 67% in group '5-6' and 33% in group '3-4'.
How can I do this?
Solved! Go to Solution.
Hi @MiKeZZa,
Based on test, I found you have added a lot of filters in visual level.
If you clean up these filter, it will shows the result as you wish.
Regards,
Xiaoxin Sheng
Hi @MiKeZZa,
Based on test, I found you have added a lot of filters in visual level.
If you clean up these filter, it will shows the result as you wish.
Regards,
Xiaoxin Sheng
Can't believe that I've missed this...
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |