Forum Discussion

cshowe80's avatar
cshowe80
Helper I
9 years ago
Solved

Creating a New Measure ...

I've got a report I'm producing to show year over year values and I've just about completed it. Now I've been given one request thats thrown me for a loop. I've got a number of "products" and in thos...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago
    Measure = CALCULATE(SUM([Column]),FILTER(Table,[Column]="Product_Sold")) / CALCULATE(SUM([Column]),FILTER(Table,[Column]="Product_Unsold"))

    Something along those lines

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi cshowe80,

If there is "Sold" and "unsold" in your "Impression Groups" column, there are Direct Sale, Affiliate, Auction, Marketing on the column based on my understading. If my understanding is right, you should use the following formula.

Sell Through = DIVIDE(CALCULATE(SUM([Total impressions]),FILTER(YOY,[Impression Groups]="Direct Sale")) , CALCULATE(SUM([Total impressions]),FILTER(YOY,[Impression Groups]<>"Direct Sale")))


Then select the measure, set it's type as percentage by Data Type under Modeling.

Please feel free to ask if you have other issue.

Best Regards,
Angelia

cshowe80's avatar
cshowe80
Helper I
9 years ago

Sorry I may have made this confusing and I think what you're saying makes perfect sense. This was a P.E.B.K.A.C error on my part that was where I was running into troubles.

 

I was successful using a modified version of the provided string

 

Sell Through = CALCULATE(SUM([Total impressions]),FILTER(YOY,[Impression Groups]="Sold")) / CALCULATE(SUM([Total impressions]))

 

Thank you for all your assistance I've finally gotten this working. :)

 

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

    Hi cshowe80,

    Glad to hear that your issue got solved. Please mark corresponding reply as answer, which will help other people find the workaround easily.

    Best Regards,
    Angelia