Forum Discussion

DavePBI's avatar
DavePBI
Frequent Visitor
6 years ago
Solved

DAX SWITCH TRUE - help needed

Hi community / DAX experts,   I need some help here on DAX statement that I cannot get working. I have 2 tables : 1) VW_Dim_Relatie (= clients table) with a column SoortRelatie with values 00010,...
DAX Calculation
DAX SWITCH
Help me
  • az38's avatar
    az38
    6 years ago

    hi DavePBI 

    it depends on your business logic.

    you should understand what exact value you want to use for define EK for each item.

    maybe AVERAGE(), maybe SUM(). its all about task

    I dont know whats the purpose of your report, what is data nature and so on..

DavePBI's avatar
DavePBI
Frequent Visitor
6 years ago

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....!!!

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

hi DavePBI 

it depends on your business logic.

you should understand what exact value you want to use for define EK for each item.

maybe AVERAGE(), maybe SUM(). its all about task

I dont know whats the purpose of your report, what is data nature and so on..