Forum Discussion
rms1
7 years agoFrequent 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"))
No RepliesBe the first to reply