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, 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

Highlighted
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

Top Solution Authors
Top Kudoed Authors (Last 30 Days)