I’m curious if anyone has further ideas that may assist with an issue in my model. I have tried the PowerBI forum but I’m only getting answers I knew and was trying to avoid.
I’ll try to summarise here but please also see my detailed post here.
I have 2 x resource tables, Actuals and Forecast. The Forecast has a lot more fields than Actuals
I have a large number of measures running over these tables so I’m hesitant to append the 2 together. I initially made the decision not to do that as I was concerned about how big it would make my model by having all the additional irrelevant forecast fields next to actuals data
I am currently using master tables to create a relationship for the 2 or 3 key columns we often use in visuals (like ‘Submitted By’) but if we drop in any of the other inconsistent fields to a visual, it will break the calculation as depicted in the post.
I’m trying to improve my knowledge by understanding if there’s a way to write a measure which would only return actuals against ‘blank’ if there is a filter on one of those inconsistent fields.
Secondary, what is best practice? Should I have just joined the 2 x tables from the get go?
Thanks in advance!