Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 !!!!!
Solved! Go to Solution.
Hi,
You may download the PBI file from here.
Hope this helps.
Hi,
Share some data, describe the question and show the expected result.
The attached sample is in the link gg drive below,
https://drive.google.com/open?id=1C1mFEY9woeijiYP-1l_AeoxpVQTror-1
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?
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,
Hi,
You may download the PBI file from here.
Hope this helps.
You are welcome.
@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?
Not sure.