Add counts to DAX

[Markzolotoy]

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

[amitchandak · Accepted solution]

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