Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Request your guidance to solve this issue
in my table "salesdistrictwise" got a text field named "status" which contains "active" or "inactive" data. I would like to get a count of "active" cases using a DAX function. please advice
regards,
dsmitha
Solved! Go to Solution.
@dsmitha ,
The following DAX Measure should work:
Active_Count = CALCULATE( COUNTA( YourTable[salesdistrictwise) ),
FILTER( YourTable, YourTable[salesdistrictwise] = "active" ))
Good Luck and Regards,
@dsmitha ,
The following DAX Measure should work:
Active_Count = CALCULATE( COUNTA( YourTable[salesdistrictwise) ),
FILTER( YourTable, YourTable[salesdistrictwise] = "active" ))
Good Luck and Regards,
Hi rsbin,
thank you very much for your express reply, it resolved the issue
thanks once again
regards,
dsmitha
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |