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!
v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, kilala 

There are no syntax errors from the current formula.

Is there any other specific error message?

Best Regards,
Community Support Team _ Eason