Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have two columns I'd like to add if both conditions are met.
If CallSource = "Call" and RecNum is True then I want to count this as 1.
LLL = COUNTROWS(FILTER(Table_Calls,Table_Calls[Callsource] = "CALL"))
How do I add the RecNum is True to this?
Thanks,
android1
Solved! Go to Solution.
Try:
calculate(countrows(Table_Calls),Table_Calls[Call_Source]="CALL",Table_Calls[RecNum]=TRUE())
Try:
calculate(countrows(Table_Calls),Table_Calls[Call_Source]="CALL",Table_Calls[RecNum]=TRUE())
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |