Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
5 years ago
Solved

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

  • 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]) )