cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
M_OVAISJANZEB Regular Visitor
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
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
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
M_OVAISJANZEB Regular Visitor
Regular Visitor

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

@Ashish_Mathur Update link: https://mega.nz/#F!TfAE2AZI!wWsZzeNUmVzfMC0yy5ROXw

 

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.

 

M_OVAISJANZEB Regular Visitor
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

Update link: https://mega.nz/#F!TfAE2AZI!wWsZzeNUmVzfMC0yy5ROXw

 

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
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])
Untitled.png

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
M_OVAISJANZEB Regular Visitor
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.

Untitled.jpg

Vvelarde Super Contributor
Super Contributor

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

@M_OVAISJANZEB 

 

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!




M_OVAISJANZEB Regular Visitor
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

 

01.png

 

 

Helpful resources

Announcements
New Kudos Received Badges Coming

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

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

Power Platform World Tour

Find out where you can attend!

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