Forum Discussion
DAX SWITCH TRUE - help needed
Hi az38,
Thanks for getting back to me. Thanks for feedback. I made a mistake on sending incorrect image on that. See below the correct one.
As you can see issue is coming from fact that it cannot find column 'IncassoProvisie_Jr' due to fact that it is a secondary linked table.
So to expain further, I have 3 tables in this setting. VW_Dim_Relatie is linked 1 to * with a 2nd table and that second table is linked with also 1 to * connection to the 3rd table VW_Fact_Dekking that holds the column 'IncassoProvisie_Jr' that I need.
Any idea to overcome this? Thanks again for feedback.
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....!!!