Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Data Multipliers

I am having to add multipliers to certain date within a table.   Example:   Channel                      Count  Digital                        1 Phone                        1 NonMarketing   ...
  • MattAllington's avatar
    9 years ago

    Create a table that contains all the multiplier options

    create a lookup Table that has all the unique chanels

    join both the count table and the multiplier table to the channel lookup table

    put the column from the channel table into rows in your visual

    create the following measures. 

     

    Total count = sum(CountTable[count])

    Multiplier value = max(MultiplierTable[multiplier])

    result = sumx(channelTable,[total count] * [multiplier value])