Forum Discussion

actzikas's avatar
actzikas
Frequent Visitor
6 years ago
Solved

Contains Operator in a Measure

Is there a way you can use a contains like operator in a measure?  What I am trying to do here is filter all activity types that CONTAINS "Call"    Number of Calls = CALCULATE(Count('Renewal Ac...
Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi actzikas ，

     

    First you need to create a calculated column to check whether the selected line has the value you need:

     

    Column = CONTAINSSTRING('Renewal Activity (Offsite Data)'[Activity Type],"Call")

    Then you can calculate the numbers of calls using a measure:

    Measure = CALCULATE(COUNTROWS(Renewal Activity (Offsite Data)),'Renewal Activity (Offsite Data)'[Column]=True())

     

    Finally it will show similarly to my sample data as below:

     

     

    Best Regards,

    Kelly

     

     

     

     

Tahreem24's avatar
Tahreem24
Super User
6 years ago

actzikas 

 Create 2 fields to accomplish your requirement:

Calculated Column = SEARCH("Call",'Renewal Activity'[Activity Type],1,0)

Measure = CALCULATE(COUNT('Renewal Activity'[Offsite Data]),[Calcualted Column],'Renewal Activity'[Activity Type])

 

I have created sample for

 

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!