Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dax date issue

Hi,   I have my date table [Date] linked with a 1 to many relationship to with Resource Annual [Date].    The simple dax below works to calculate the first date in the series as the Production St...
DAX
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Your first post indicated that filtering wasn't happening and your last one suggest too much filtering is happening.  In any case, ALLSELECTED will not remove filters coming from slicers outside your matrix.  You need to use ALL instead.  For example,

 

Production Year = CALCULATE(MIN('Resource Annuals'[Date]), ALL('Resource Annuals'))

 

Regards,

Pat