Measure output is not matching after removing blank values

[Anonymous]

Team,

Please help me.

I am using same measure in both the visuals, in the bottom visual I have filttered the values if the values are gratter than 0. You can see same in image 3, in image 2 I am trying to show which values I have removed. My ELST values are not matching but down level valeus are matching ELST- Sauces and FS & ELST - TK values are matching, not sure how to fix this issue please help.

 

Thank you in advance!

[v-jingzhan-msft]

Hi @Anonymous 

In the last measure [HW CTSP], try using DIVIDE(AbsDiff, Max_Denominator) to substitute (AbsDiff/Max_Denominator). 

Best Regards,
Jing

[Anonymous]

This will give 100% instead of NaN

My measure totals are not matching in metrix visual which is causing the problem