Measure that does not take the slicer into account

[Charline_74]

Hello,

I created this measure to obtain the sum of my sales for the earliest date (1/02/17) in my data :

At month Period-2 = CALCULATE(

    SUM('KEYFIGURES_MV2 (2)'[Value]),

    'KEYFIGURES_MV2 (2)'[ACTUAL_FLAG] = "B",

    'KEYFIGURES_MV2 (2)'[L_PERIOD_NAME_DATE] = MIN('KEYFIGURES_MV2 (2)'[L_PERIOD_NAME_DATE]),

    ALLEXCEPT('KEYFIGURES_MV2 (2)','KEYFIGURES_MV2 (2)'[Attribute]))

However, despite the use of ALLEXCEPT when I choose a period in my slicer, the data displayed is not the right one.

Any ideas?

[v-zhangti · Accepted solution]

Hi, @Charline_74 

As I understand it, your desired result is that the value of the earliest date should be displayed regardless of which date is selected.

You can try the following formula:

At month Period-2 =
CALCULATE (
    SUM ( 'KEYFIGURES_MV2 (2)'[Value] ),
    FILTER ( ALL ( 'KEYFIGURES_MV2 (2)' ),
        'KEYFIGURES_MV2 (2)'[ACTUAL_FLAG] = "B"
            && 'KEYFIGURES_MV2 (2)'[L_PERIOD_NAME_DATE]
                = CALCULATE (
                    MIN ( 'KEYFIGURES_MV2 (2)'[L_PERIOD_NAME_DATE] ),
                    ALL ( 'KEYFIGURES_MV2 (2)' )
                )
    )
)

If this does not solve your problem, please provide more information.

Best Regards,

Community Support Team _Charlotte

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