Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need help with couting duplicated rows if there is data in at least one column.
As you can see in the date column there are duplicates. I want the date/hours to be counted only once, but only if there is data in at least one of "Count 1", "Count 2" or "Count 3".
Solved! Go to Solution.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
pls try this
Thanks! I combined your answer with @amitchandak's answer by adding [Date] at the end so that it only counted the registration as one.
Flag1 = IF(([Count1] + [Count2] + [Count3])>0, [Date])
@trndlnd , Try a measure like
Countrows(Summarize(filter(Table, [Count1] >0 || [Count2]>0 || [Count3]>0),Table[Date]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |