Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filters

Hi , I am new to PowerBI. I have a question related to filters. I want to calulate the count of Id's only if my Status column has 'Failed' as its value. If 'Failed' value is not flowing into the rep...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a measure like

    calculate(count(Table[Id]), filter(Table, Table[Status] ="Failed"))

     

    or in your existing measure add +0

    example

    count(Table[Id]) +0

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try a measure like

calculate(count(Table[Id]), filter(Table, Table[Status] ="Failed"))

 

or in your existing measure add +0

example

count(Table[Id]) +0