Filter takes only in consideration some columns

[Fragan]

Hey,

I have this table :

I have this Measure that does cumulative sum of Attribute1 :

Measure2 = 

SUMX (
    DISTINCT ( 'Table3'[attributes] );
    SWITCH (
        'Table3'[attributes];
        "Attribut3";CALCULATE ( SUM ( 'Data'[value] ); Filter(ALL('Data'); 'Data'[date] <= MAX( 'Data'[date]) && 'Data'[attributes] = "Attribut1") );
            var a = 'Table3'[attributes] return
        CALCULATE ( SUM ( 'Data'[value] );'Data'[attributes]=a)
    )
)

I want to create a histogram using this, and the problem is that using this measure it's impossible to apply a filter to the histogram. For example if i add "group" as the first axis of the histogram, i get the exact same value for Attribut3 for both groups.

Ifixed this by changing my mesure to :

Measure2 = 

SUMX (
    DISTINCT ( 'Table3'[attributes] );
    SWITCH (
        'Table3'[attributes];
        "Attribut3";CALCULATE ( SUM ( 'Data'[value] ); Filter(ALLEXCEPT('Data';Data[group]); 'Data'[date] <= MAX( 'Data'[date]) && 'Data'[attributes] = "Attribut1") );
            var a = 'Table3'[attributes] return
        CALCULATE ( SUM ( 'Data'[value] );'Data'[attributes]=a)
    )
)

But here im telling him manually to exclude Data[group] from filters. Is there anyway to tell him to take only Data[date] and Data[attributes] ?

Regards

[Greg_Deckler]

Not sure I am understanding this fully. In your second formula, you are starting with a filter context that includes the filter context for your group column, which it sounds like is what you want. Then you are filtering that down from there for data and attribute columns. Correct?

[Fragan]

@Greg_Deckler 

In the first measure, the cumulative sum was working, but i noticed that i couldn't apply visual "Group" filter. So i added the ALLEXCEPT and the visual filter worked.

My question is : how to include only date and attributes in the filter ? 

[Greg_Deckler]

OK, this is where I am getting confused. You say you want the visual filter for Group and then you say it works and is good but then you turn around and say you don't want it. If you don't want it, go back to the first formula?

[Fragan]

@Greg_Deckler 

What im looking for is an Alternative for

ALLEXCEPT('Data';Data[group])

Instead of excluding Data[group] from the filter, i want to specify only the columns i want to include(which are Data[date] and Data[attributes]).

[V-lianl-msft]

Hi @Fragan ,

Please try to replace

ALLEXCEPT('Data';Data[group])

with 

ALLEXCEPT('Data';'Data'[date];'Data'[attributes])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

OK, maybe KEEPFILTERS or REMOVEFILTERS, I can't make heads or tails of what you want. If the ALLEXCEPT works I don't understand why you need an alternative to it. And it sounds like you want it, but then you say you don't. ALLEXCEPT doesn't exclude group from the filter, technically, it maintains the filter for group but not for anything else.