Forum Discussion
Allocated accounting
How do I do allocated accounting in Power BI? I have one table that contains cost rows. ID Product ID Cost 01 01 100 02 02 100 And second table that tells how costs should be allo...
While working on the issue I have located my problem.
When using calculated column (allocation * sum('Costs'[Cost])) it gives me right answer. But if I have page level filters or try to use date slicer to filter costs table the calculated column doesn't give right answer.
So... How do I get my filters to work with calculated column.