Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]))
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |