Revenue grouping

Hi punnas1 ,

How about this:

GroupMeasure = 
CALCULATE (
    [Revenue AC],
    ALL ( Groups ), 
    VALUES ( SalesTable[Group Name] )
)

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Hi, punnas1 

How did you get your Max and Min and is it as shown below?

Column:

Max = 
CALCULATE(MAX('Groups'[Value]),FILTER('Groups',[Group Name]=EARLIER('Groups'[Group Name])))

Min = 
CALCULATE(Min('Groups'[Value]),FILTER('Groups',[Group Name]=EARLIER('Groups'[Group Name])))

If your source data differs, please provide partial example data.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.