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
Highlighted
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, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
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 Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)