cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Data Multipliers

I am having to add multipliers to certain date within a table.

 

Example:

 

Channel                      Count 

Digital                        1

Phone                        1

NonMarketing           1

Radio                         1

 

Where Channel = Broadcast , multiply count by .369

Where Channel = Radio, multiply count by 4

 

Then I have to total all counts, including multipliers. Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Data Multipliers

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])



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
2 REPLIES 2
Super User
Super User

Re: Data Multipliers

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])



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Community Support Team
Community Support Team

Re: Data Multipliers

Hi @ThePowerBIQueen,

 

Could you please mark the proper answer if it's convenient for you? That will be a help to others.

 

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.