[Pct Sold Smart] Measure Matches [Shape Pct Sold] at the Shape Level (Orange Cells) But Matches [Raw Pct Sold] Down at the Color Level
Quick Post Today
I’m halfway on vacation today in Florida, visiting family, so I will keep this brief. I saw this question today on the forums.
Sales and Stock Tables
The question is pretty simple – I have a Sales table and a Stock table:
Sales Table – the Numerator of our Pct Sold Measure
Stock Table – the Denominator of our Pct Sold Measure
And we want a measure that returns Percentage Sold.
But there’s a twist: at the Shape level, we want to use something other than Stock as the total. We want to use another cap, a Shape-Level cap:
At the Shape Level, We Want to Use These Values (Instead of Stock) as the Denominator