Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Peeps. I need some help. I am trying to create a measure within a column in PBI Desktop with DAX. I have a column called QOS and I want to determine the NSAT. This means I need to count the values (rows) within the column and subtract them from the grouped sum. For example: Sum the count of the 1, 2, 3, and 4 values and the subtract the sum of the count of the 8 and 9 values.
8 = 18
9 = 42
Sum is 60
1 = 3
2 = 11
3 = 2
4 = 6
Sum is 22
Measure should be the output of 60 - 22=38
Solved! Go to Solution.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |