Calculate measure


Hi Sam,

Is there a particular reason you used the Sales Data table to filter the Channel instead of the Channel table. Is it best to use the dimension table so when there are no sales for a particular channel it is picked up. I have included a screen shot of the video detail.





The video you referenced has no Channel table in it. If you go back to around 2:30 into the video you will see that the Channel table isn’t there on the right.

Based on that CALCULATE removes the original filters and applies the Channel from the Sale Data table where it is equal to Wholesale.

Much later in Sam’s videos he does create other supporting tables to do the same thing.



Hi Guy,

Yes now makes sense now. Thank you. The channel table is in sample file provided for the video hence assumes we were using the same model.