Forum Discussion
Add counts to DAX
I have the following DAX:
EVALUATE SUMMARIZECOLUMNS('bv_demisto_incidents'[account], 'bv_demisto_incidents'[Severity], FILTER(VALUES('bv_demisto_incidents'[account]), ('bv_demisto_incidents'[account] = @Company)))
Severy comes in many categories. How can I add counts column for each category into this expression? Currently the result might look like this:
company1 a
company1 b
company1 a
company1 b
I want:
company1 a 2
company1 b 2
Thanks
Markzolotoy , Try like
EVALUATE SUMMARIZECOLUMNS('bv_demisto_incidents'[account], 'bv_demisto_incidents'[Severity], FILTER(VALUES('bv_demisto_incidents'[account]), ('bv_demisto_incidents'[account] = @Company)) , "_count", count('bv_demisto_incidents'[account]) )
1 Reply
- amitchandakSuper User
Markzolotoy , Try like
EVALUATE SUMMARIZECOLUMNS('bv_demisto_incidents'[account], 'bv_demisto_incidents'[Severity], FILTER(VALUES('bv_demisto_incidents'[account]), ('bv_demisto_incidents'[account] = @Company)) , "_count", count('bv_demisto_incidents'[account]) )