Forum Discussion

Meetsangoi's avatar
Meetsangoi
New Member
3 years ago

Need a solution

I am trying to built one Excel report in power Bi and i have a formula in Excel need to implement same in power Bi =COUNTIF(M3:U3;"Yes")/9

 

 

 

 

1 Reply

  • Meetsangoi , You can not do it same manner in power bi

     

    Countx(Filter({[M3], [N3], [O3]}, [Value] = "Yes"), [Value]) /9

     

    Add all columns