Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi - please can someone help me. I need to create a measure to only count the ones per column? e.g there would be 3 for Declined.
Solved! Go to Solution.
Hello, if you only want to count the "1" in declined, then just do the follwoing
COUNTROWS(FILTER(table, table[declined] = 1))
or
CALCULATE(count(table[declined]), table[declined] = 1)
Perfect - Thank you!
Hello, if you only want to count the "1" in declined, then just do the follwoing
COUNTROWS(FILTER(table, table[declined] = 1))
or
CALCULATE(count(table[declined]), table[declined] = 1)
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |