Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

ALLEXCEPT not ignoring filters

Ultimately I am building a measure that looks like this: CALCULATE(SUM(Table[Amount]), FILTER(ALLEXCEPT(Table, Table[Project]), Table[Date] <=SELECTEDVALUE(Table[Week]))) This calculates a JTD ...
Need Help
  • az38's avatar
    az38
    6 years ago

    @hahl

    Yes, exactly. wrong copy and paste 😞

    Measure = 
var _endDate = CALCULATE(MAX('CalendarTable'[Date]))
RETURN
CALCULATE(SUM('Table'[Amount]),FILTER(ALLEXCEPT('Table','Table'[Project]),'Table'[Date]<= _endDate ))

    Безымянный.png

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, I'm not looking for relative date filtering. I need JTD amounts where the week is the end date, so filtering by the week only wouldn't get me what I need.

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

what else filter do you need? filter by project is included in my statement

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Sorry az38 I'm not good at tagging who I'm talking to 🙂

    You got it right, the project filter is the only filter I need besides it looking back at all the historical data before the selected week.
    I've been using one project as a example, because I've manually pulled out the data I want and it is there. But when I add a slicer for project and select this example project the measure both you and I created returns a blank value. Even when I can see it's not the case from the actual data. 

    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Anonymous 

      could you show the data example?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        az38 
        Sure thing, I just created a sample file, how do I share it?