cancel
Showing results 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
Highlighted
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
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
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

Announcements

#### New Topics Started Badges Coming

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

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

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

Top Solution Authors
Top Kudoed Authors (Last 30 Days)