Issue with DAX / modeling for financial report

[MarieD]

Hi all,

I’m working on a financial report and once of the pages will contain a Balance Report. There are 5 different companies (called Administraties) and it must be possible to select one of them via the on page slicer and then the balance should only show the figures for that company.

The balance result contains the Openingvalues for the beginning of the year and then adds the mutation in this year to it.

And there is one calculated value in de balance (the current year result, calculated as Resultaat with a manually added Account number 9999) to make sure the balance will be equal to the Debit side of it.

This all works fine when NO selection is made in the slicer, but when you select only 1 company, it will keep showing the total result for all companies. This will off course show an incorrect number.

To solve this, I have tried to calculate the Result in a different way and as you can see in the table on the right, and this gives the total result in a breakdown per Company. But I can’t get this new measure working in the final view I need for the report.

I think I need to change something in DAX or in the model itselves but I’ve already tried a lot of things, but nothing is giving the expected result 😞

Dummy file can be downloaded here: https://we.tl/t-BVLxe5IrFy

It would be great if somebody can point me into the right direction to get this working…

Kind regards Marieke

[MarieD]

hi,

Yes off course, please see attachment. 

I have calculated the results per company, but I have now idea how to combine that into my final measure as the final measures keeps returning the total amount for all companies.
If you select a company in the slicer on top of the sheet, for example seledt code '164442',  the result in the final measure should be 50958. And for company code '164443', it should be 41946. so the numbers in the most right column of the table are the ones that should be returned in the final measure for accountnr 9999.

hope this will make it more clear now 🙂

[DimaMD]

Hi, @MarieD  Can you provide your desired result?