cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
corpsikumar
Helper I
Helper I

Max Value of each quarter and then sum for each category

Hello Community,

 

I'm trying to create measures for MAX QTD & Sum of MaxQTD. First For each Name i have to find max value of Enrollment for 

each quarter and then i have to do sum of that new measure.

corpsikumar_1-1664553564045.png

 

You can see in the above data For Name "ABC" i need get max value for each quarter and if multiple Names appears in same quarter then i have to sum the max QTD. 

 

Desired Output would be MAX QTD and then SUM of MAX QTD is like for 

Q1 - 440

Q2 - 400

Q3 - 300

 

For Q-1 i have only one name i.e "ABC" so the output of MAX QTD & SUM of MAX QTD would be same.

For Q-2 also i have only one name i.e "DEF" so the output of MAX QTD & SUM of MAX QTD would be same.

But For Q-3 i have 2 Names ABC & BCD i have calculate max value of quarter for each Names and then Sum.

Max of each names for Q-3 is 150 each and Sum of max value is 300

 

Please help.

 

 

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

ahahaha - 2/30/2022  -  nice try.

 

Based on your sample data the maximum for ABC in Q3 is 200, not 150. So the total is 1190

 

lbendlin_1-1664660562248.png

 

see attached

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

ahahaha - 2/30/2022  -  nice try.

 

Based on your sample data the maximum for ABC in Q3 is 200, not 150. So the total is 1190

 

lbendlin_1-1664660562248.png

 

see attached

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors