topic Revenue grouping in DAX Commands and Tips

Revenue grouping

punnas1 — Sun, 24 Apr 2022 11:08:37 GMT

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]))

Re: Revenue grouping

tackytechtom — Sun, 24 Apr 2022 11:22:33 GMT

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/

Re: Revenue grouping

v-zhangti — Wed, 27 Apr 2022 03:21:08 GMT

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.