Forum Discussion

rms1's avatar
rms1
Frequent Visitor
7 years ago

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"))
No RepliesBe the first to reply