Maxx of concatenated columns?

[VuongLM93]

Dear all,

I have a report connecting to a data model in my company,

I cannot add table/ columns....but only measures since this model was not created by me,

I have 2 table with following columns

Dim - Product:  Brand - Flavour - Pack type - Pack Size - SKU name - SKU Code

Fact - Inventory : Inventory  (other columns were hide by admin I think)

Currently a have a measures to see maximum inventory in a month filter :

MAXX (KEEPFILTERS (VALUES ( SKU Code) ) ,Calculate (Inventory))

This works well but I dont want SKU Code, but a concatenated column of : Concatenate(Brand - Flavour - Pack type - Pack Size). 

since I am not allowed to create additional column in this data model, is there anyway to modify the measure to get the desired result ?

Thanks so much !!!!!

[Ashish_Mathur]

Hi,

Share some data, describe the question and show the expected result.

[VuongLM93]

The attached sample is in the link gg drive below,

https://drive.google.com/open?id=1C1mFEY9woeijiYP-1l_AeoxpVQTror-1

@Ashish_Mathur 

[Ashish_Mathur]

Hi,

Show the exact result that you want to see in the Putput worksheet so that i can tally my formula's result with your expected result.  Also, in the Dim-Distribotor Table, how can one distributor have 2 codes.  Is that a mistake?

[VuongLM93]

@Ashish_Mathur 

sorry I have refresh the data and output again,

Yes Somestimes 1 Distributor Code have 2 name in reality , but I will just keep the unique values only,

Basically I want the a Measure to show the Maximum of values ,

If filter by month then it will be the maxiumum of all dates in that month only,

[Ashish_Mathur · Accepted solution]

Hi,

You may download the PBI file from here.

Hope this helps.

[VuongLM93]

@Ashish_Mathur  working like magic, lots of thank to your help !!

[Ashish_Mathur]

You are welcome.

[VuongLM93]

@Ashish_Mathur  After scaling to 60 SKU x 330 Distributors and 2018 - 2019 daily,

this "measure" become very slow to calculate,

I don't know if the Summarize is the problem?

[Ashish_Mathur]

Not sure.