TabularEditor / TabularEditor3

Bug reports, feature requests, discussion and documentation for Tabular Editor 3 (commercial version).
63 stars 7 forks source link

DAX debugger evaluation context problem #817

Open zayca opened 1 year ago

zayca commented 1 year ago

Hi, I am newbie and a user of 30 days trial at the moment but I have probably found an issue. I just installed it to inspect filter contexts. As far as I know If tables are just connected via date column or if a table is marked as date table (and connected via other column) - DAX applies implicit filter ALL['dates')]. In the second option Tabular editor takes this filter into account in Evaluation Context window and it shows the final result properly and displays this implicit filter and crossed out outer filters. But if the tables are connected via [date] column this information in not present (and outer filter context is not crossed out) but it should be.

mlonsk commented 1 year ago

Hi @zayca We will look into it and get back to you. Thank you for reporting :)

mlonsk commented 1 year ago

Hi @zayca We have confirmed this a bug. Well spotted!

zayca commented 1 year ago

Thx for Your answer. Good to hear that. Dax is a nightmare and this implicit filter for date has a very specific behaviour so I even asked Alberto Ferrari on SQLBI what is going on. I thought that maybe Your trial version would help me to figure it out...and the bug made me think I still don't understand it.