Sum of max in a day and ignore other filter

[Pheroxiz]

Hello everyone,

Given the table name is Table1

Day        I Number I   Type
1-Jul-24 I      20     I     A
1-Jul-24 I      10     I     A
2-Jul-24 I      10     I     B
3-Jul-24 I      5       I     C
3-Jul-24 I      8       I     C
4-Jul-24 I      5       I     C

I would like to create a measure that reflect the sum of max number in a day whether I used a slicer to filter type or not. However, the total number should still consider the day slicer.

For example,
W/O day slicer: regardless of which type I filter out, the measure should be 20+10 + 8 + 5 = 43
Filter out 4-Jul-24: The measure should be 20 + 10 + 8 = 38

Your help is appreciated!

[Gabry · Accepted solution]

Hello @Pheroxiz ,

this is you measure 

MXS = CALCULATE(SUMX(SUMMARIZE('Table', 'Table'[Day], "Max", MAX('Table'[number])),[Max]), ALL('Table'[type]))