Forum Discussion

Sdg8481's avatar
Sdg8481
Helper I
8 years ago
Solved

FILTER(ALL on multiple

Hi,   I have a simple table with Date, Product Name and Value. I need a measure that will provide a Total 'value' for the dates <=  a date chosen by the user, of which the following works fine:   ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Sdg8481,

    Base on my test, we can use the function ALLEXCEPT instead of ALL here to make the product name keeping filtered.

    So we can create a measure using the formula as below:

    ALLEX := CALCULATE(Sum('0 - Measureables'[Value]),(FILTER(ALLEXCEPT('0 - Measureables','0 - Measureables'[Product]),'0 - Measureables'[Date]<=(MAX('0 - Measureables'[Date])))))

    After that we can get the result that we need.

     

    For more information, please refer to the pbix as attached.



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sdg8481,

Base on my test, we can use the function ALLEXCEPT instead of ALL here to make the product name keeping filtered.

So we can create a measure using the formula as below:

ALLEX := CALCULATE(Sum('0 - Measureables'[Value]),(FILTER(ALLEXCEPT('0 - Measureables','0 - Measureables'[Product]),'0 - Measureables'[Date]<=(MAX('0 - Measureables'[Date])))))

After that we can get the result that we need.

 

For more information, please refer to the pbix as attached.



Regards,
Lydia

Sdg8481's avatar
Sdg8481
Helper I
8 years ago

Brilliant Thank you.