Reply
Highlighted
Frequent Visitor
Posts: 4
Registered: ‎12-05-2018

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"))