Forum Discussion

Ramendra's avatar
Ramendra
Helper IV
5 years ago
Solved

calculate syntax

Hi  Team,   Can some one help me to  know for below syntax in Power BI measure   Count column A values if column B contains  value=XYZ and  if  column c contains value= ABC  or  PQR
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Ramendra 

    Just add a NOT to that part:

    Measure = CALCULATE(COUNT(Table1[ColA]), Table1[ColB] ="XYZ", NOT Table1[ColC] IN {"ABC", "PCR"} )

     

    Please mark the question solved when done and consider giving kudos if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

AlB's avatar
AlB
Community Champion
5 years ago

Hi Ramendra 

 

Measure =  CALCULATE(COUNT(Table1[ColA]), Table1[ColB] ="XYZ",  Table1[ColC] IN {"ABC", "PCR"} )

 

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

Ramendra's avatar
Ramendra
Helper IV
5 years ago

Hi AlB ,

Thanks  for help.
Can you please  also let me know what to mention instead of  "IN" if I want to apply like below  for "Table1[ColC] IN {"ABC", "PCR"} )"

 Table1[ColC] does not equal to "ABC" or  "PCR"