cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rms1 Frequent Visitor
Frequent Visitor

Filter with Text for multicoulumn in measure

I am able to get count for blank records from two columns but not able from another value exists record
 
BlankCountmeasure =
CALCULATE(COUNTBLANK('data'[level 2]),FILTER('data','APM_data'[level 1]= "Customer Relationship Management"))
 
Not working measure as below
 
FieldEngineerCountMeasure =
CALCULATE(COUNT('data'[level 2]),FILTER('data','APM_data'[level 1]= "Manager")
,FILTER('data','APM_data'[level 2]= "FieldEngineer"))