Forum Discussion

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago
Solved

LIKE % operator in Power BI

Hello All,

 

I'm craeting a measure, but running into a problem.

 

Here is my measure

COUNT ROWS =

CALCULATE(COUNTROWS('TABLE1'),
FILTER ('TABLE1', AND ('TABLE1'[Type] = "C",
AND(
'TABLE1'[Category] = "RED",
'TABLE1'[Industry] <> "%SER%")))) -- This is the fileter I need to apply,
--to remove Industry does not conatin SER in the Industry name
)

Thanks
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    Hello sabeensp 

    Give this a try 

    COUNT ROWS = 

CALCULATE(COUNTROWS('TABLE1'),
FILTER ('TABLE1', AND ('TABLE1'[Type] = "C",
AND(
'TABLE1'[Category] = "RED",
NOT CONTAINSSTRING('TABLE1'[Industry], "SER")))))

1 Reply

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    7 years ago

    Hello sabeensp 

    Give this a try 

    COUNT ROWS = 

CALCULATE(COUNTROWS('TABLE1'),
FILTER ('TABLE1', AND ('TABLE1'[Type] = "C",
AND(
'TABLE1'[Category] = "RED",
NOT CONTAINSSTRING('TABLE1'[Industry], "SER")))))