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 

6 Replies

  • 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"

    • 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" for  Table1[ColC] IN {"ABC", "PCR"} ) if I want to  apply like below for  same syntax.

       

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

      • AlB's avatar
        AlB
        Community Champion
        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 

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Ramendra , Try like

    calculate(count(Table[ColumnA]), filter(Table, Table[column B] ="XYZ" && Table[column B] in {"ABC","PQR"}))

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    5 years ago

    Hi Ramendra ,

     

    Are the answer helpful for you? If yes, please kindly accept as solution. If you still need help, please share some sample data with us. Thanks.