Dax ROWCOUNT with multiple filters

[Anonymous]

I have a following query that works fine in sql server and i want to avoid importing in PBI as a direct query so i decided to use DAX function to achieve the same. Below is the SQL query that i want to convert it to DAX function

SELECT COUNT(severity) as Count_Informational
FROM dbo.jamming
where jamNumber = 'JAM2010077' AND jamVersion = '2.2.2' and Jamtool = 'zinga'
AND (severity = 'low') AND (status <> 'obsolete')

Note: The following values ('JAM2010077', '2.2.2','zinga','low' ,'obsolete') are filtered () via drillthrough , lets say from dashboard A and will be filtered and passed into Dashboard B (will be used in the DAX function), I have no experience with DAX so any help will be appreciated. Thank you.

[Anonymous · Accepted solution]

Hi @Anonymous 

Create a measure like this :

Measure = CALCULATE(COUNT('Table'[severity]),FILTER('Table','Table'[jamNumber] = "JAM2010077" && 'Table'[jamVersion] = "2.2.2" && 'Table'[Jamtool] = "zinga" && 'Table'[severity] = "low" && 'Table'[status] <> "obsolete"))

Then add the visual in a card visual , you will get a result like this :

I have attached my pbix file , you can refer to it .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you very much !

[SpartaBI]

@Anonymous somthing like:

MEASURE = 
CALCULATE(
	COUNTROWS('jamming'),
	'jamming'[jamNumber] = "JAM2010077",
	'jamming'[jamVersion] = "2.2.2",
	'jamming'[Jamtool] = "zinga",
	'jamming'[severity] = "low",
	'jamming'[status] <> "obsolete"
)ow') AND (status <> 'obsolete')

      

Showcase Report – Contoso By SpartaBI