Forum Discussion

cshowe80's avatar
cshowe80
Helper I
9 years ago

Summing Multiple New Meassures

I've got a new issue I'm looking to resolve with the help of the PowerBI gurus here. I could be doing this incorrectly so please give me any feedback you feel is important.    I've got a new report...
Need Help
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

cshowe80

 

Hello, Create a calculated column for the rate for each product.

 

RateProduct=Switch('Table1'[Ad Request Size]);1;25;2;20;3;40;4;50)

 

Create a measure:

 

TotalProjectedRevenue=Sumx('Table1';'Table1'[ForecastedImpressions]*'Table1'[RateProduct])

 

 

 

 

cshowe80's avatar
cshowe80
Helper I
9 years ago

Sorry to be so dense but I've never done calculated columns before and I'm poor at DAX at the moment. As I'm sure my posts show I'm abit of a novice working towards more proficiency. I've got a tab in my excel report (the data source for this PowerBI report) named Creative Map. This tab is to map the ad request sizes (one of which shows multiple possibilities) to new sizes. In this table I also have rates for each of these items. 

 

Am I able to use these rates in this table and apply them to the other table which has the forecasted sales of each of these items? 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi cshowe80,

    Am I able to use these rates in this table and apply them to the other table which has the forecasted sales of each of these items? 

    Yes, you are. First you need to create a relationship between these two tables, then you should be able to use RELATED Function (DAX) to create the measure like below.

    TotalProjectedRevenue =
SUMX (
    'SalesTable';
    'SalesTable'[ForecastedImpressions] * RELATED ( 'Creative Map'[RateProduct] )
)

    Regards