Forum Discussion
Solved
Allocation based off different table
Hi All, I'm trying to allocate out a specfic dollar amount based on a table I have built. I have a allocation table that will include percentages. As a order comes in I want it to reference that ...
Hi powerBIpeon ,
You could use RELATED() function to do it like the following DAX:
Column 1 = VAR a = RELATED ( 'allocation table'[Module 1] ) * Quotes[Price] RETURN SWITCH ( TRUE (), a = 0, BLANK (), a )Here is my test file for your reference.
Hi powerBIpeon ,
what is you desired outcome? A table in your model with the item code and the price allocated to the modules? Or do you want to visualize it in a table vizualization?
Cheers,
Sturla
