Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 wa...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you very much !