Adding a fix value to a Total

Hi,

To answer this properly a bit more context would be good. My guess based on the information you provided is that the matrix shown in second picure might use the same dimensions as the one above. Because of this the selectedvalue might get incorrect values and thus it won't return 678. My second guess is that you might have filtered the "interco capital returned" row accidentally. The base issue is likely that the filter context is messed up somehow. 


Here is an example to clarify what I mean:

Test data:

Theory A (selectedvalue doesn't find the correct row):

Dax:

Measure 22 = var _sel = SELECTEDVALUE('Table (28)'[Hierar chy]) RETURN

SWITCH(_sel,

"A",1,

"B ",2)

Here I added a whitespace behind "B". Now the switch won't find a match and only Dim A values are returned:
 

 

Theory B. Slicers affecting the visual:

Dax:

Measure 22 = var _sel = SELECTEDVALUE('Table (28)'[Hierarchy]) RETURN

SWITCH(_sel,

"A",1,

"B",2)

Now the dax works when no slicers are applied:
But when I select only dim A and B the value under hierarchy B (C) is not displayed:

In your case I recommend testing what values your 

VAR SelectedRollUpFunction = SELECTEDVALUE('ZTBR'[Roll_Up_Function], "None")

Is returning (place it into a separate measure and test the values on matrix level).  Additionally see what kind of slicers are affecting your visual.


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/