Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Calculation to a specific channel.

Hi all, 

 

I am creating a report to count the individual sales per channel.

 

This is usually an easy task to master; but I am having to do a different step: 

 

There are 5 distinct channels:

Broadcast

Digital

Social

Offline

Other

 

Before displaying the total sals per each; there should be an underlying measure for Radio's count. 

 

Broadcast = total sales( count of calls * multiplier)

 

How do I incorporate this into a single table along with the count of all the other channels?

 

If you need more information; I will provide!

 

Thanks.

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    HI Anonymous,

     

    It will be help if you share some sample data to test.

     

    Regards,

    XIaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      There is a matrix with a final result that looks like this:

       

       

       

      There are multiple Channels in one field.. And one "Total Sales" number that is being filtered by month. 

       

      The problem is... there is a different calculation for one specific channel.. that can't be applied to the rest. 

       

      The 'Broadcast' channel......

       

      The formula for the broadcast channel looks like this:

       

      = Total YTD Broadcast Sales + (# of broadcast sales MTD * .168)

       

      How do I get this Calculated into this matrix without it being applied to any other channels??

       

      Anonymous

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        HI Anonymous,

         

        >>How do I get this Calculated into this matrix without it being applied to any other channels??

        Write a measure to instead the default summary column, add if statement to check channel name to switch different calculation formula.

         

        Sample:

         

        Check Masure= 
var current_channel=LASTNONBLANK('Table'[channel],[channel])
return
IF(current_channel="Broadcast","specify formula","YTD formula")

         

         

        Regards,

        Xiaoxin Sheng