Forum Discussion
Helper IIIALL() giving performance issues
Community SupportHi fjjpeeters1976
Thanks for getting back!
To help us understand the issue better, could you let us know which part of the calculation seems off is it the NetResult, Bal, or ProResult? Also, are you testing the formula in a specific visual like a matrix or card, or looking at it from a total level?
Let us know if there are any filters applied, such as year, entity, or scenario. Lastly, if possible, please share what result you were expecting and what value you’re seeing instead.
This will help us verify whether it’s a context evaluation issue or something specific to your data model.
Helper IIIHi, thanks for your reply.
I put my old and the new measures on a card visual next to eachother to make sure they all have the same filters applied to them. There are filters on year, entity and some other criteria, but they are same for both.
Comparing the three parts of the calculation. In the new calculation logic both netresult and proresult are giving me exactly 25% which is equal to both factors that I multiply with (25%). So it feels like in the new situation the denominator and the numerator are the same number ending up at value 1 which is multiplied than with the factor.
In the correct version the netresult should end up at 11% and the proresult at 10.28% totalling to 21.28%.
Regarding the balancesheet part, I have an issue with the uploaded datapart so both of them are giving me a blank value at the moment, but I assume this is more a dataload issue than a DAX issue. When the upload is corrected I can check this part as well.
Hope this clarifies it a bit. Love to hear your thoughts. Due to the size and confidentiality of the data I unfortunately cannot provide you with a data-extract.
BR,
Frank