Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Exclude nulls and whites from the calculation

Hi, I need help to fix a measure I created, I need my measure to consider only the middle column values ​​that are not null or blank:   And my measure is this way today:   (IndicatorValue [...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Anonymous,

     

    Please add a MAX() function for the Equipment [name],

     

    Total of Units Rejected test = CALCULATE (sum (IndicatorValue [Value]); FILTER (Indicator; Indicator [Name] = "UnitsRejected" && not (isblank (MAX(Equipment [name])))))

     

    Best Regards,
    Qiuyun Yu

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

vanessafvg

yes

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi Anonymous,

 

Please add a MAX() function for the Equipment [name],

 

Total of Units Rejected test = CALCULATE (sum (IndicatorValue [Value]); FILTER (Indicator; Indicator [Name] = "UnitsRejected" && not (isblank (MAX(Equipment [name])))))

 

Best Regards,
Qiuyun Yu