Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Measure to ignore date slicer help

I am trying to calculate the sum of sales (in combined table) for the Version and 2 clients listed in the measure below when the Revenue Date (column in the Combined Table) equals the EOM of the slec...
Need Help
mh2587's avatar
mh2587
Icon for Super User rankSuper User
2 years ago
Test = //Try this one
VAR _SelDate = MAX('Date'[Date])
VAR _Day = SELECTEDVALUE('Date'[Day])
VAR _EOM = EOMONTH(_SelDate, 0)

RETURN
CALCULATE(
    [Combined Total Revenue],
    'Combined All'[Version] = "Prediction",
    'Combined All'[Profitability Customer] IN {"ClientA", "ClientB"},
    FILTER('Date', 'Date'[Date] = _EOM)
)