Forum Discussion
Strange evaluation context behavior on a calculated table using UNION()
I have a data model consist of two dimension table and one fact table as below. The fact table is consolidated from various ERP account receivable aging reports. Each open AR item is identifed...
Does it work properly when only having two dimensions connecting FT_AR Aging table? Can you verify the data in FT_AR_Collection table?
In this scenario, make sure your columns order are same in both tables when using UNION() to combine them. And based on your Excel source table, it seems there's no fact data for those ARs under that selected company code.
If this issue still persists, can share your .pbix with some sample data?