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


 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
If your table is linked to another via 1:*, then, first of all, there may be many values in the second table for a single row in the first table and secondly, to reach the "many" side of the relationship you have to use RELATEDTABLE.

I'd suggest you think well over again what you want to do because what you are trying to do right now is not doable.

Best
D