Issue with context Transition

[campelliann]

Hi,

I am creating a calculated column on the table "Beebole_Time_export" with this dax Calculate(Firstnonblank(RH_historico_diário[name],1). I was getting always a blank value, so I got suspicious of a context transition problem. I use Calculate( firstnonblank, all Beebole) solves the issue. Now If I also use Calculate (firstnonblank(all(calendar)) . It solves the issue. 

It seems to me that it is the Calendar propagating some filter, to RH historico Diario Table. The thing I dont get is this, Beebole time export cannot filter Calendar, so how on earth the context transition on Beebole is affecting calendar?

Thanks!

[AlB]

Hi @campelliann 

See if this other post can help

https://community.powerbi.com/t5/Desktop/Weird-behavior-after-creating-relationship/m-p/1575539

Mark as Date table - SQLBI

MDX and DAX topics: DAX Time Intelligence Functions (mdxdax.blogspot.com)

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[campelliann]

Nope :).

I am creating a calculated column on beebole time export with Calculate(Firstnonblank, RHhistorico[column). I was getting a blank, meaning that RH historico is being "filtered", if I use remove filters the issue is solved. What I do not understand is how this happens, because filters cannot flow between these two tables..