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 report, I need to show '0' else count(Id). Any help is much appreciated. Thanks in advance

--Jyothi Sree

 

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

1 Reply

  • 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