Forum Discussion

powerBIpeon's avatar
powerBIpeon
Helper II
6 years ago
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 ...
Need Help
Tutorial Requests
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

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.