Forum Discussion

richard-powerbi's avatar
richard-powerbi
Post Patron
6 years ago
Solved

Overwrite data from different fact table when available

How do I create a measure or a table with DAX to get calculated Table 3? And how would I do it if I wanted just the measure for Value of Table 3? Assuming I have common dimensions. So when data ex...
Need Help
  • AlB's avatar
    AlB
    6 years ago

    richard-powerbi 

    Assuming the field in the visual is the TableX[Id]:

    Measure =
VAR valT2_ =
    LOOKUPVALUE ( Table2[Value], Table2[Id], SELECTEDVALUE ( TableX[Id] ) )
RETURN
    IF (
        ISBLANK ( valT2 ),
        LOOKUPVALUE ( Table1[Value], Table1[Id], SELECTEDVALUE ( TableX[Id] ) ),
        valT2_
    )

     

    Please mark the question solved when done and consider giving kudos if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

richard-powerbi's avatar
richard-powerbi
Post Patron
6 years ago

AlB Thanks! Is a measure also possible if I just want to return the Value?

AlB's avatar
AlB
Community Champion
6 years ago

richard-powerbi 

A measure tobe used where and how? and to yield what result exactly? You talked about a calcualted table. Try to make it clearer with an example

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

  • richard-powerbi's avatar
    richard-powerbi
    Post Patron
    6 years ago

    Let's say I have a visual and I have Id from the dimension on the axis, and I want to show Value like it is in Table 3 in the Values of the visual. I think a measure would then be more suitable than a whole table?

    • AlB's avatar
      AlB
      Community Champion
      6 years ago

      richard-powerbi 

      Assuming the field in the visual is the TableX[Id]:

      Measure =
VAR valT2_ =
    LOOKUPVALUE ( Table2[Value], Table2[Id], SELECTEDVALUE ( TableX[Id] ) )
RETURN
    IF (
        ISBLANK ( valT2 ),
        LOOKUPVALUE ( Table1[Value], Table1[Id], SELECTEDVALUE ( TableX[Id] ) ),
        valT2_
    )

       

      Please mark the question solved when done and consider giving kudos if posts are helpful.

      Contact me privately for support with any larger-scale BI needs, tutoring, etc.

      Cheers