Forum Discussion
Solved
Actual vs Budget problem with Invoices
Hello all, I have issue with my visual. PBIX can be downloaded from this link. Slow Free dowload should take 12 seconds. https://ulozto.net/file/IvbI0fYg7rAG/actual-vs-budget-problem-with-...
Budget and Variance values in the pictures provided don't match the data in the pbix.
However, the problem is that you don't want to show values at the Invoice level so what about changing the measures to be like:
Budgets = IF (ISINSCOPE(Actual[Invoice]), BLANK(), sum(Budget[Budget])),
the Variance measure will also need changed.
Let me know what you think.
I can't help you with that, sorry. I know nothing about the xviz hierarchy filter and half the visual is blocked for me (due to having to register it or something).