4 tables are linked via two tables and I have realtionships between them. All is working fine. I have as well date table but that has same concept.
NC Table =
UNION ( VALUES(Actual[Nominal]), VALUES(Budget[Nominal]),VALUES('Nominal Code Map'[Nominal]))
Contract Table =
UNION ( VALUES(Actual[Contract]), VALUES(Budget[Contract]),VALUES('Contract Map'[Contract]))
Up to now I was always showin Actual vs Budget & Variance on Contract & Nominal Level. No issue with that.
Now I need to show Inovices under nominals. I have separete visual which use Power apps and flow to donwload copy of invocie via API. That element is working fine but slecting right invoice is trigger for the flow.
Problem is with Budget & Variance on Invoices. Budgets are only on nominal Level and you can see that visual doens't work. I have example with table and Hierarchical Filter from Xviz. I am using this filter as it is easier to filer one invoice for my additonal flow.
Are you able to help me out? I need to deliver this tomorrow and I am lost.
I need to deliver one of these 3 outcomes. Prefferably Option A (Budget & Variance will not be shown on Invocies)
Option B have budget on all invoices. Not ideal but better than now. Option C have Budget divided by number of invoices.