calculate syntax

[Ramendra]

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

[v-xuding-msft]

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.

[amitchandak]

@Ramendra , Try like

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

[AlB]

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]

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 · Accepted solution]

@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 

[Ramendra]

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"