Forum Discussion

kilala's avatar
kilala
Resolver I
4 years ago
Solved

Add Condition in Calculated Column

Hi all,   I have 2 Fact Tables, FactA and FactB. FactB needs to get info from FactA. Both FactA and FactB can connect via PayerKey. In FactA, there is DateKey, referring to reportingdate. In FactB,...
Need Help
Show and Tell
  • kilala's avatar
    kilala
    4 years ago

    Hi everyone, 

    I tried to use this formula and apparently it works! 

    CALCULATE([Measure],ALLEXCEPT(vw_FactB,VW_DIMPAYER[PayerKey]))
     
    I think I dont have connect to FactB since I already have it in my measure.
     
    Thanks everyone!
kilala's avatar
kilala
Resolver I
4 years ago

Hi everyone, 

I tried to use this formula and apparently it works! 

CALCULATE([Measure],ALLEXCEPT(vw_FactB,VW_DIMPAYER[PayerKey]))
 
I think I dont have connect to FactB since I already have it in my measure.
 
Thanks everyone!