Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Creating a measure from two other measures

I have a table (Measures) that is composed entirely of measures that are all created from at least two tables. I need to create a new measure, that when used in a matrix, will only calculate when ano...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you amitchandak  and mahoneypat  for your suggestions - unfortunately neither seem to have worked. Please see the below matrtix. The actual outcome for cost/plays at the "USA" level ($0.62) should be the same as the "LinkedIn" level $(0.35). I am starting to suspect an issue with the summing and subtotaling (as cost/play for "programmatic should be $0, as no items with plays had any associated spend) but I could be wrong

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    For posterity's sake (and anyone that may care), I seem to have found a solution. 

     

    I created a new measure (Vid_cost) that only sums the spend for items that have video views using Calculate, sumX, and IF:

     

    vid_cost = calculate(sumx(SiteTable, if([Video Plays]>0, [Spend], BLANK())))
     
    I can then adjust the Cost/Plays formula to calculate using the Vid_Cost measure, resulting in a correct total and subtotal at both the publisher and country level.