Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello!!!
I have two measures, one that calculates the weight of sales per item (%Weight) and another that calculates the unit price ($Unit Price)
I need to find a measure that assigns me a unit price for each item.
The unit price I need has to be the one with the highest % weight per item.
My database is the blue part, my measurements are the green part, and the measurements I need are the brown part.
I hope you can help me, thank you so much! 🙂
Hi,
This should typically be solved with a calculated column formula in the Table. If you are OK with my approach, then share the download link of the PBI file. If possible, pleasure ensure that column names are in English.
@Lucy_Ramirez Does something like this work for you?
MAX percentage =
CALCULATE ( MAX ( Sheet1[Percentage] ), ALLEXCEPT ( Sheet1, Sheet1[Product] ) )
MAX units =
CALCULATE ( MAX ( Sheet1[Units] ), ALLEXCEPT ( Sheet1, Sheet1[Product] ) )
43.39Hello!
No, I need to assign a price of the maximum weight.
for example for tostada nachos, te maximum weight is 43.39%, so I need that in all article the price be $4.
Any thoughts?
Thankyou!
@Lucy_Ramirez @Ashish_Mathur is right. Calculated columns should be used.
Thanks to @wdx223_Daniel for the solution.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |