Forum Discussion

SravaniBudde's avatar
SravaniBudde
Frequent Visitor
3 years ago

COUNTIF function in power bi

Hi , I am trying to convert excel fromulas inot power bi. Can u please help in convert this. 1.COUNTIFS([@[REJECTED_DATE]],">0") 2.COUNTIFS(Table1[@[ESCAL_TO1]:[ESCAL_TO3_DT]],">0")
Need Help
SravaniBudde's avatar
SravaniBudde
Frequent Visitor
3 years ago

Hi ,

 

Thanks for the reply.

 

But for the first formula mentioned if i use it am getting wrong value for my data set . May i know what could be reason.

PhilipTreacy's avatar
PhilipTreacy
Super User
3 years ago

Hi SravaniBudde 

 

I don't know.  I'd need to see your file to see what is going on.  Can you provide it please.

 

regards

 

Phil

  • SravaniBudde's avatar
    SravaniBudde
    Frequent Visitor
    3 years ago

    It is resolved isntead i created custom column instead measure column. it resolved my issue now. how can i keep blank values count to 0