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

     

     

     

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
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