Skip to main content
cancel
Showing results for 
Search instead 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

Reply
KristinaSp
Helper I
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.

 

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

 

Data example:

 

DateCategoryTypeValue
2022-10-01A1st10
2022-10-02A1st11
2022-10-03A2st12
2022-11-10B2st14
2022-11-03B1st9
2010-10-04B1st2
2022-10-03A1st10
2022-10-01B2st16
2022-10-02A2st18
2022-11-03B2st8
2022-11-03C2st7
2022-11-03C1st3
2022-10-01C1st4
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Nofil098_0-1669200288342.png

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

 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Nofil098_0-1669200288342.png

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

 

KristinaSp
Helper I
Helper I

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

dateCategoryTypeValue
2022-10-01A1st10
2022-10-02A1st11
2022-10-03A1st10
2022-10-01C1st4

 

menglaro78
Employee
Employee

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 !!

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!

Helpful resources

Announcements
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

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