Nested if ...else not summing the second condition

[jmuthoni]

Hi, 

I am currently building a "what if analysis " app. 

The following is my script:

if($(Return to normal) = 5/1/2020 and $(Cycle time) <90,

sum({<Month={'4/1/2020','5/1/2020'}>}[Implant forecast] +

$(Opportunities already in the funnel)/8 + $(New Opportunities in April 2020)/8),

if($(Return to normal) = 5/1/2020 and $(Cycle time) <90,

sum({<Month={'6/1/2020'}>}[Implant forecast] +

$(Opportunities already in the funnel)/2)

))

The first sum works fine, but the second one does not sum up the cell?   Could someone please advise on what I am missing ?

Thanks,

Muthoni

[Wlad_Masi]

Hi @jmuthoni,

I am not sure I understood your question,
Are you saying that the first line of the table in the image is correct, but the other two lines should not be split in 2 values?
If this is what you are talking about, it is respecting your dimension values, so it won't sum up on a single line. Measures are calculated respecting dimensions.

If I did not understand it correct, do you mind replying with an example of the outcome you are looking for?

[Wlad_Masi]

Hi @jmuthoni,

Please let me know if you still need help on your problem.