Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |