Forum Discussion

htalat6's avatar
htalat6
Frequent Visitor
3 years ago

Calculation in measure

Hey i am trying to recreate this calculated field on Power BI

I want to calculate number of times this situation occurs , i used the following type of formula on tableau. Because of limitations i am moving to Power BI so need help.

 

sum( if columna = 'abc' and (columnb = 'fg' or columnc ='th') then 1 end)

 

Thanks in advance

Need Help
Tutorial Requests

2 Replies

    • htalat6's avatar
      htalat6
      Frequent Visitor
      3 years ago

      Hey Chris ,

      Thanks for the reply i think it will do it . what function here should i use to sum the trues? sum()?