Sum of max values per category and type and selected date

[KristinaSp]

Hello,

I need to calculate sum of max values per category, type and selected date (year, month, day, specific period - I have directly related calendar table).

I have tried to do it with summarize function, but it didnot wortk flexibly with calendar.

Could you help me with this task? Thank you in advance

Data example:

Date	Category	Type	Value
2022-10-01	A	1st	10
2022-10-02	A	1st	11
2022-10-03	A	2st	12
2022-11-10	B	2st	14
2022-11-03	B	1st	9
2010-10-04	B	1st	2
2022-10-03	A	1st	10
2022-10-01	B	2st	16
2022-10-02	A	2st	18
2022-11-03	B	2st	8
2022-11-03	C	2st	7
2022-11-03	C	1st	3
2022-10-01	C	1st	4

[Nofil098 · Accepted solution]

Measure = Max(main[value])
If your problem is resolved then do hit the like.

[KristinaSp]

Additional coment, for example:
if i use slicers:
date: october
type: 1st
 the sum of max values would be:
A category max = 11
C category max = 4
Sum of max: 11+4 = 15

date	Category	Type	Value
2022-10-01	A	1st	10
2022-10-02	A	1st	11
2022-10-03	A	1st	10
2022-10-01	C	1st	4

[menglaro78]

HI @KristinaSp ,

try with this, if I understand yout question

Measure = CALCULATE(MAX(TableTest[Value]), all(TableTest[Type]))

Marco

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[KristinaSp]

Unfortunately, this formula does not work for me. I have added additional comment about expected result.  maybe you could check and will have an idea how to wirte the formula. Thank you for your help!