Filters

[Anonymous]

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

[amitchandak · Accepted solution]

@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