Forum Discussion
DAX SWITCH TRUE - help needed
Community ChampionThe issue is you have a few related rows from VW_Fact_Dekking table
So, you have to define logic to what exactly related value you want to use. It can be MAX, MIN, SUM, etc.. or FIRSTNONBLANK.
for example
EK =
var _IncassoProvisie_Jr = CALCULATE(FIRSTNONBLANK(VW_Fact_Dekking[IncassoProvisie_Jr]);1)
RETURN
SWITCH(TRUE();
VW_Dim_Relatie[SoortRelatie] = "00010" && _IncassoProvisie_Jr=0; "0";
VW_Dim_Relatie[SoortRelatie] = "00010" && _IncassoProvisie_Jr < 100; "PB";
"no_status"
)
or
EK =
var _IncassoProvisie_Jr = CALCULATE(MIN(VW_Fact_Dekking[IncassoProvisie_Jr]))
RETURN
SWITCH(TRUE();
VW_Dim_Relatie[SoortRelatie] = "00010" && _IncassoProvisie_Jr=0; "0";
VW_Dim_Relatie[SoortRelatie] = "00010" && _IncassoProvisie_Jr < 100; "PB";
"no_status"
)
Hi az38,
Thanks so much for that. Really helpfulp it provides no errors anymore and returns the value.
It seems I am almost there, however when checking the label (like PB etc). It seems not to be correct always. Sometimes it should return a PZ but then gives a PG label...
Maybe this comes due to fact that I used SUM in the logic line. I did that as there are in _Incassoprovisie_Jr multiple rows with value within one single Relation, so that is why I took SUM. But maybe that is the issue and I should be usings something else instead?
Thanks again you are of great help....!!!