Revenue grouping

[punnas1]

Hi,

I am trying to create a measure for the sum of sales by the group. I had tried the following DAX formula however it not working and showing total sale in each group)

Groups = CALCULATE([Revenue AC],FILTER(Groups,[Revenue AC]>=Groups[Min]&&[Revenue AC]<Groups[Max]))

[tackytechtom · Accepted solution]

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/

[v-zhangti · Accepted solution]

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.

[tackytechtom · Accepted solution]

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/