Hi,
I did this calculation and it´s ok:
Measure =
SWITCH(
SELECTEDVALUE( Refugo[Processo]),
"Manual", IF ([MediaRefugoMoldador] <0.01,1, IF([MediaRefugoMoldador] >=0.01 && [MediaRefugoMoldador] <=0.02,0.5, IF([MediaRefugoMoldador] >0.0201, 0))),
"Cold box", IF ([MediaRefugoMoldador] <0.01,1, 0),
"Squizzer", IF ([MediaRefugoMoldador] <0.01,1, IF([MediaRefugoMoldador] >=0.01 && [MediaRefugoMoldador] <=0.02,0.5, IF([MediaRefugoMoldador] >0.0201,0)))
)
If I try to multiple it by a value using this way, numbers come wrong, in this case a solution for sure would be super nice, but an explanation of why this is happening will help me in the undestand what is going on behind the DAX scenes. Thanks.
Measure2 =
SWITCH(
SELECTEDVALUE( Refugo[Processo]),
"Manual", IF ([MediaRefugoMoldador] <0.01,1*[PremioMesManual], IF([MediaRefugoMoldador] >=0.01 && [MediaRefugoMoldador] <=0.02,0.5*[PremioMesManual], IF([MediaRefugoMoldador] >0.0201, 0))),
"Cold box", IF ([MediaRefugoMoldador] <0.01,1*[PremioMesColdBox], 0),
"Squizzer", IF ([MediaRefugoMoldador] <0.01,1*[PremioMesSquizzer], IF([MediaRefugoMoldador] >=0.01 && [MediaRefugoMoldador] <=0.02,0.5*[PremioMesSquizzer], IF([MediaRefugoMoldador] >0.0201,0)))
)
Sample data here https://1drv.ms/u/s!AktM4_8VYySOiJNesEmXB9u11SPH3A?e=WUlZvp
