MAX of calculation, with filter

[blazko]

Hi, I have small problem with creating a measure. Here's what I got:

max/day = IF(
    ISFILTERED('a/b'[a/b]);
    MAXX(
        'BASE data';CALCULATE(SUM('BASE data'[qty]);ALLEXCEPT('BASE data';'BASE data'[date];'BASE data'[a/b])));
    MAXX(
        'BASE data';CALCULATE(SUM('BASE data'[qty]);ALLEXCEPT('BASE data';'BASE data'[date]))))

And I have problem this working with a "a/b" slicer. 

It should calculate max of qty sum calculated by a day, from selected time period. In this example a date hierarchy in matrix visual, with a drill down option through year, quarter, month, week.

The problem is I figured out something that works only partially. With one or none selection (isfiltered: true/false). What i want is that this calculation worked also with both options selected on slicer (sum a+b).

Thx in advance for any reply.

[Anonymous]

Hi @blazko,

Maybe you can try to use below measure if it works for your requirement:

Check Range =
MAXX (
    SUMMARIZE (
        FILTER (
            ALLSELECTED ( 'BASE data' );
            'BASE data'[a/b] IN ALLSELECTED ( 'a/b'[a/b] )
        );
        [date];
        [a/b];
        "SUM"; SUM ( 'BASE data'[qty] )
    );
    [SUM]
)

If above not help, please provide some sample data for analysis.

Regards,

Xiaoxin Sheng

[blazko]

Hi, thanks for the responce, sadly yours solution wasnt working for me. 
Found one of my own, simple:

max  = MAXX(calculated_date;MAXX(calculated_date;CALCULATE(SUM('BASE data'[qty]))))

And it calculates through all the slicers I can get from the table, not only "a/b".