Forum Discussion

phb's avatar
phb
Frequent Visitor
4 years ago

Calculate remaining budget between two tables

I have been stuck on this problem for weeks.   I have the following data model:      rap_Sag is the project rap_Sagsplanlægningslinjer is the budget for a project rap_Sagspost is the con...
phb's avatar
phb
Frequent Visitor
4 years ago

Anonymous ,

Thanks for your reply, but it doesn't solve my problem. You can find a sample report here https://www.dropbox.com/s/h5uvmdlot3obv15/Sample%20report.pbix?dl=0 (It doesn't seem like I can upload here). 

 

The problem is that have a mandatory column (kategori), but it should only be shown if the column has any values like the example below. Budget is not shown for K3, because it doesn't have values. 

 I tried solving it with three measures like the one below, but then the columns are always shown.

 

I can't figure out how to calculate "Restbudget" which is just "Budget" - "Forbrug" when I can't show columns without values.