Forum Discussion

markpatton's avatar
markpatton
Icon for Helper I rankHelper I
4 years ago

Ignoring relationships when using lookup value or alternative

I have two tables that I want to cross reference. The tables are also used for other funcions so they have active relationships based on dates, etc.   I want to do a lookup from one table to anothe...
Need Help
bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,
Without seeing your data model it's hard to work out exactly what you're trying to do however you might find...

CROSSFILTER - DAX Guide with the 3rd parameter set to "None" within a CALCULATE statement.

However I think more likely you want to remove any filters coming from the date table?

 

Eg
CALCULATE (
[Your Measure],
REMOVEFILTERS(Date)
)