Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a table as shown in the image with opportunity codes that are unique and do not repeat and I also have a column that is the ID_Cliente that can be repeated several times.
I want to get a calculated column that puts me "1" for each id_cliente counted only 1 time, but it is counting me only the only ones with this DAX formula
I want you to tell me both the only ones that are not repeated, as well as the repeated but counted only 1 time. So the table would look as shown in the image. I appreciate any ideas or help.
Solved! Go to Solution.
Hi @Syndicate_Admin ,
Update your counting formula for :
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Hi Could you help me with this request, I'm trying to place this formula, if(CALCULATE ( COUNT ( 'Table'[id] ), ALL except ( 'Table','Table'[id] ) )=1,1,blank()), but I can't find the count function and the third criterion of the if function (i.e. the blank one) doesn't work.
Hi @Syndicate_Admin ,
Update your counting formula for :
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |