Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Set Default Value

I have a Fact Table with the Names and the Target Table with the Target and Default Target. I want to consider the Names from Fact Table and the Targets from the Target Table, where the names ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago
    Final Target = VAR __var = IF(Fact[Names] = RELATED('Target Table'[Name]),RELATED('Target Table'[Target]), RELATED('Target Table'[Default Target]))
RETURN IF(ISBLANK(__var),1,__var)
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    You could do something like:

     

    Final Target 1 = VAR __var = IF(Fact[Names] = RELATED('Target Table'[Name]),RELATED('Target Table'[Target]), RELATED('Target Table'[Default Target]))
RETURN IF(ISBLANK(__var),MAXX(ALL('Target Table'),[Default Target]),__var)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago
Final Target = VAR __var = IF(Fact[Names] = RELATED('Target Table'[Name]),RELATED('Target Table'[Target]), RELATED('Target Table'[Default Target]))
RETURN IF(ISBLANK(__var),1,__var)
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Greg_Deckler It's working. Thankyou! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Greg_Deckler

     

    I have a followup question. Is there any chance to use the Default target column instead of hard coding the default value?

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      8 years ago

      You could do something like:

       

      Final Target 1 = VAR __var = IF(Fact[Names] = RELATED('Target Table'[Name]),RELATED('Target Table'[Target]), RELATED('Target Table'[Default Target]))
RETURN IF(ISBLANK(__var),MAXX(ALL('Target Table'),[Default Target]),__var)
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Greg_Deckler Thank you!