Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have been trying to count the values in a column. I have tried the belwo
Count Kit Bags = DISTINCTCOUNT(PPECheckinOut[ScanKitBagTag])
the result should be 16 but it reuturns 17 (counting the duplicate value).
can anyone help as to why or how to get it to count only values that are unique and not balnk.
Thanks
Solved! Go to Solution.
And this
Measure 2 = SUMX ( ALL ( PPECheckInOut[ScanKitBag ], PPECheckInOut[ Crabs] ), CALCULATE ( VALUES ( PPECheckInOut[ Crabs] ) ) )
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |