Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need your help to solve a problem. I have tried various solutions that I have read on the forums but that does not help me.
I have this kind of data :
Several references belonging to the same team and with the same number.
Dont add all numbers but only 1 times by ID
And I would like to get this kind of results via a matrix.
thank you in advance for your help.
Solved! Go to Solution.
Hi @Milozebre,
You can create a calculated table to list all distinct ID, Team values:
Table = SUMMARIZE('Table1',Table1[ID],'Table1'[Team],"Value",MAX('Table1'[NUMBER]))
Then drag that [ID] and [Team] to matrix Row group, [Value] to Values.
Best Regards,
Qiuyun Yu
Another option is to use the Query Editors remove duplicates function. Just select the 4 columns and click remove duplicates
Hi @Milozebre,
You can create a calculated table to list all distinct ID, Team values:
Table = SUMMARIZE('Table1',Table1[ID],'Table1'[Team],"Value",MAX('Table1'[NUMBER]))
Then drag that [ID] and [Team] to matrix Row group, [Value] to Values.
Best Regards,
Qiuyun Yu
First thank you for your reply.
This is exactly the result I was hoping for.
I hadn't thought of SUMMARIZE 😞
I realize that I still have some way to go 🙂
A big thank-you
Another option is to use the Query Editors remove duplicates function. Just select the 4 columns and click remove duplicates
Thank you for your reply
Two solutions 🙂
I am a taker because I am fond of learning and I realize that with the many features of Power Bi and DAX, I have enough to take care of for a long time 🙂
Thank you
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHI MFelix,
Thank you for your reply.
I have already tried but it doesn't work.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |