Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
looking for help to solve with the following, probably standard, scenario.
I need to calculate the total price ( quantity * rate) for each transaction of the Lanes table. Ultimately i need to compare prices to find the lowest bid.
So, i was trying to define a measure to do the following:
For each supplier multiply quantity * rate giving the following conditions:
Lanes[Lane ID] = Quotations[LaneID]
Lanes[Bracket] = Quotations[Bracket]
I solved this problem in the past creating calculated columns to calculate prices for each and every supplier individually.
The data model can be simplified as shown below:
Two tables:
Lanes (fact table)
Quotations
You may consider using RANKX Function to add a calculated column first.
Column = RANKX ( CALCULATETABLE ( Quotations, ALLEXCEPT ( Quotations, Quotations[LaneID], Quotations[Bracket] ) ), Quotations[Rate], , ASC, DENSE )
thank you very much.
Actually, i found this example and it is exactly what i am looking for.
However, although i am following the instructions it does not work for me. This is the error message i am getting:
"A table of multiple values was supplied where a single value was expected"
Any ideas?
Thank you very much!
Take a good look at LOOKUPVALUE Function.
Hi @onkelphill,
Have you resolved this problem? If not, share the link from where i can download you file and also show your expected result there.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |