Forum Discussion
Data Multipliers
- 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])
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])