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

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