Forum Discussion

jmkvalsund's avatar
jmkvalsund
Icon for Helper III rankHelper III
3 years ago
Solved

Using measure in a DAX filter does not work

Im trying to use a measure in a DAX filter to count the numbers of customers for each Key Account Manager (KAM) at a given date, but it does not seem to work. My measure is calculated like this, a...
"CALCULATE"
"FILTER"
"MEASURE"
  • johnt75's avatar
    johnt75
    3 years ago

    Does it work if you store the result of the measure in a variable ?

    M_NumberOfCustomersTwoMonthsAgo =
VAR ReferenceDate = [M_StartDate2MonthsInterval]
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'Sales'[CustomerID] ),
        'Sales'[KAM_email] = "[email protected]",
        'Sales'[DateID] = ReferenceDate
    )
jmkvalsund's avatar
jmkvalsund
Icon for Helper III rankHelper III
3 years ago

I tried your solution, but it didn't change anytning. And as far as I can see, the only difference is that the FILTER statement is written explicitly instead of being implisitt in the CALCULATE statement. 
M_NumberOfCustomersTwoMonthsAgo is still (Blank) when using M_STartDate2MonthsInterval as value for criteria.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Are you certain that you have sales on the exact date in question ?