cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Calculated Column with Summarize and Max

Hello,

 

I'm trying to create an calculated column that will take the max group by company . So That I can use this column as slicer for filter

 

CompanycolorColumn
c11_red1_red
c11_red1_red
c10_Green1_red
c22_yellow2_yellow
c21_red2_yellow

 

 

column = summarize(Table, Table([Company], "Test", Max(Table(color))

 

 

Below is the code, that I have been playing around with. I need this as an column.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Calculated Column with Summarize and Max

@Anonymous try this expression to add column

 

Max Color = 
CALCULATE( 
MAX ( 'Table (2)'[color] ), 
ALLEXCEPT( 'Table (2)', 'Table (2)'[Company] ) 
)

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Calculated Column with Summarize and Max

@Anonymous try this expression to add column

 

Max Color = 
CALCULATE( 
MAX ( 'Table (2)'[color] ), 
ALLEXCEPT( 'Table (2)', 'Table (2)'[Company] ) 
)

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Anonymous
Not applicable

Re: Calculated Column with Summarize and Max

@parry2k that actually worked. Didn't know it was this easy. I was able to add additional column also. Appreciate help. 

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors