cancel
Showing results for
Search instead for
Did you mean:
Regular Visitor

How to Get Maxx Value By Group And Multiple with Location Value

Hi Everyone,

I am facing issue to get max value using measure. I have 98 locations, 16 District and 3 regions,

I want to get max value by District which is merged into 8 groups

I want to get potential Gross Profit = (MTD Sales/MTD Traffic) * Max Value By District Group

Bi & Database File = https://mega.nz/#F!TfAE2AZI!wWsZzeNUmVzfMC0yy5ROXwhttps://mega.nz/#F!TfAE2AZI

thank you

8 REPLIES 8
Super User

Re: How to Get Maxx Value By Group And Multiple with Location Value

Hi,

That link asks for a decryption key.  Share a simple dataset, describe the question and show the expected result.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Community Support Team

Re: How to Get Maxx Value By Group And Multiple with Location Value

HI @M_OVAISJANZEB .

I' like to suggest you create a measure formula with variable and summarize function to summary these records, the use iteration function maxx to get max one from summarize records.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |
Highlighted
Regular Visitor

Re: How to Get Maxx Value By Group And Multiple with Location Value

I have traffic value for how many customers visit my 98 store and Sales numbers.

I divided sales (SBI) by traffic to get Revenu per Traffic (RPT)

I have 16 districts which combine in 8 groups.

I want to get the highest RPT value by a group and multiply with traffic to get = Potential Gross Profit

hope that works.

Regular Visitor

Re: How to Get Maxx Value By Group And Multiple with Location Value

@v-shex-msft Sorry I didn't understand if you share some Dax code may b that work

My Question and simple data

I have traffic value for how many customers visit my 98 store and Sales numbers.

I divided sales (SBI) by traffic to get Revenu per Traffic (RPT)

I have 16 districts which combine in 8 groups.

I want to get the highest RPT value by a group and multiply with traffic to get = Potential Gross Profit

Super User

Re: How to Get Maxx Value By Group And Multiple with Location Value

Hi,

Try this measure

MAX RPT = MAXX(ALL(Groupbytraffic[Group Name]),[RPT])

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Regular Visitor

Re: How to Get Maxx Value By Group And Multiple with Location Value

hi @Ashish_Mathur i use your measure but don't match with my excel version requirement values are wrong.

Super Contributor

Re: How to Get Maxx Value By Group And Multiple with Location Value

Hi, try using this

`MAX RPT = MAXX(All(Locations[Location_Id]),[RPT])`

Regards

Victor

Lima - Peru

Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Regular Visitor

Re: How to Get Maxx Value By Group And Multiple with Location Value

Hi, @Vvelarde thank you for contribution.

that measure get correct Max Value
But there is one issue. What do I want the location we assigned in a group. that particular Max value of that group Applies to their sub-locations.

thank you

Helpful resources

Announcements

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,441)