Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

ALLEXCEPT problem

I have a simple table set up: I'm creating an array that uses a DateDimension[BiWeekly PPE] slicer. For a row in the array, I need to override the slicer, as I need all numbers to be display...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Ok! Table 1 needs added to AllExcept filter:

    Number.M =
    Calculate(sum(Table2[Number]),
    filter(ALLEXCEPT(Table2,Table1,Table2[UniqueID]),
    Table2[Date]>SELECTEDVALUE(DateDimension[BiWeeklyPPE])))

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Options

 

 

When you select a date, you get data for more than the selected date. But you can display dates more than that. there you need an independent date table. I have shared video link for that

Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak oh i see your meaning. I'm using dropdown in the slicer. User selects a BiWeekly PPE.

 

The issue is I am losing the relationship between Table1 and Table2 with this formula.

Column Headers come from Table1; Number.M needs to come from Table2.

If I set it up so that the Column Headers came from Table2 it would work fine, but it's not possible. How to restore the relationship/link between the tables?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Ok! Table 1 needs added to AllExcept filter:

    Number.M =
    Calculate(sum(Table2[Number]),
    filter(ALLEXCEPT(Table2,Table1,Table2[UniqueID]),
    Table2[Date]>SELECTEDVALUE(DateDimension[BiWeeklyPPE])))