The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I am trying to count how many times something in column one matches what is in column 2. I have put an example below -
I would like to count how many times the proof contact is the same as the sales person. Can anyone help? A total count is fine, so in this example it would be 2.
Thanks,
Solved! Go to Solution.
Hi, this measure will do the trick:
Hi, this measure will do the trick:
Hey @Anonymous ,
using DAX you can create a calcualted column like so:
isequal = IF(<tablename>[Sales person] = <tablename>[Proof contact] , 1 , blank() )
Then you can use the new column on a card visual.
Hopefully, this provides what you are looking.
Regards,
Tom
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |