cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Sum of max values per category and type and selected date

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.

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
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

4 REPLIES 4
Anonymous
Not applicable

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

Helper I

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

Employee

HI @KristinaSp ,

try with this, if I understand yout question

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

Marco

Helper I

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!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors