Forum Discussion
Dax ROWCOUNT with multiple filters
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.
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.
3 Replies
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 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')
