What's wrong with my DAX measure?

[KenZ555]

Hi all, got a question happened on me twice:

I was learning PowerBi following some toturial video. When creating a new measure with DAX, for example, calculate the variance between two type of revenue, I used exact DAX but got the result is zero. I checked DAX it's 100% correct so I'm very confused where's the problem. or is it just my PowerBi desktop doesn't function well 😞

Has anyone encounter this before?  

[rsbin · Accepted solution]

@KenZ555 ,

Appears you are using the exact same Filter in both VAR's.  Hence, both results will be the same.

Change the Filter in VAR CommercialRevenue to "Commercial", not "Residential".

Hope this will solve your issue.

Regards,

[KenZ555]

champion!  thank you so much!!

[rsbin]

@KenZ555 ,

No worries.  Glad it all worked out for you.

Please Kudo the response and accept as Solution to close out the thread.

Good Luck on your journey.

Regards,