Unable to mutiply lookup value in measure
Hi all, need some help as I am unable to mutiply value that lookup to another table . Here are the measure created : var first_rate = LOOKUPVALUE(Tariff_Info[Price (RM)],Tariff_Info[ID],1) var second_rate = LOOKUPVALUE(Tariff_Info[Price (RM)],Tariff_Info[ID],2) var price_first_rate = IF([4.Daily Energy Chiller 2] = BLANK(), 0 , [4.Daily Energy Chiller 2] * first_rate) var price_second_rate = IF([4.Daily Energy Chiller 2] = BLANK(), 0 ,([4.Daily Energy Chiller 2] - 200) * second_rate) var total = IF([4.Daily Energy Chiller 2] = BLANK() || [4.Daily Energy Chiller 2] < 200 , price_first_rate, price_first_rate + price_second_rate ) return total result i am getting : result i am expecting : table that i lookup : If i manually add the value for first rate into the measure , i am able to produce expected result. Any idea on why i am unable to use variable to store and use the value that i want. Thanks, Hairul
Multiplying Single Values by A Measured Column Total in Table
I have numeric values (1,2,3,4,etc) in one column, and I want to multiply each of these values by the total of a different, measured column. Is this possible within Power BI? For example, in Power BI, I utilized the distinct count formula to give me the distinct count of shipments ( "Distinct Count (Y)" ). I also have basic column that gives me the total cost of that shipment ( "X" ). Then, I created a measure that divided Total Cost by the Distinct Count of Shipments ( "X/Distinct Count (Y)" ). Now, I have another column that has difference in the distinct count of shipments between this month and last month ( "Z" ). My goal is to multiple each of the values in "Z" by the total of "X/Distinct Count Y". The total of "X/Distinct Count Y" is basically the overall average cost per shipment. Hope this explanation helps. I created this example in excel to visualize what I am looking to accomplish.
