topic Dax ROWCOUNT with multiple filters in DAX Commands and Tips

Dax ROWCOUNT with multiple filters

Anonymous — Tue, 21 Jun 2022 11:56:47 GMT

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.

Re: Dax ROWCOUNT with multiple filters

SpartaBI — Tue, 21 Jun 2022 14:02:34 GMT

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

Re: Dax ROWCOUNT with multiple filters

Anonymous — Fri, 24 Jun 2022 02:23:21 GMT

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.

Re: Dax ROWCOUNT with multiple filters

Anonymous — Mon, 27 Jun 2022 07:59:31 GMT

Thank you very much !