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

[Anonymous]

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

[v-shex-msft]

HI @Anonymous .

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

[Anonymous]

@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

[Ashish_Mathur]

Hi,

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

[Anonymous]

@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.

[Ashish_Mathur]

Hi,

Try this measure

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

[Anonymous]

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

[Vvelarde]

@Anonymous 

Hi, try using this

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

Regards

Victor

Lima - Peru

[Anonymous]

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