In the case of creating a calculated column,
CALCUATE (Sum('product'[Unit Price])), there is filter context since CALCULATE turns row context into filter context. Am I correct to say that the filter context will use the index column of the table as a filter context hence why the result is different for each row. I am trying to understand what the formula used as its filter context to get a different result for each row.
Thanks in advance.