Measure is not working with the fact table date column

[Anonymous]

Hi all,
I went thorugh a conditional formatting task in power bi.

I want to understand the behaviour of power bi that when I use a measure with fact table date column it's not giving the desired result. 

Measure = IF([Availability1] = "Reserved", BLANK(),IF([Availability1] = "Free", "Green", IF([Availability1] = "Off", "Yellow", "Red")))
Result with fact table date column

When I use a different date table, its giving me result on the same measure I have created
Result with the date table "date" column

Please help me to know the reason behind it.

Thankful to you all 

[Anonymous]

Hi @Anonymous ,

What's your logic of measure [Availability1], I think such different outputs may be related to the context of [Availability1].

If possible , please share your pbix file after removing sensitive data to help us clarify your scenario.

Best Regards,
Eyelyn Qin

[Anonymous]

Thanks for your precious revert.

I have attached the link of the file

https://drive.google.com/file/d/1BJKCcPvgQxTHdEz_GDUhpOy2kwBMixH-/view?usp=sharing