The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
244 | |
127 | |
119 | |
81 | |
78 |