Forum Discussion
Issue with context Transition
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!
2 Replies
Hi campelliann
See if this other post can help
https://community.powerbi.com/t5/Desktop/Weird-behavior-after-creating-relationship/m-p/1575539
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.
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..
