Hello,

A very simple question trying to understand the Calculate function.

For the below measure, If I dont specify the column field for the table in the filter context , then on what basis the sum gets calculated. If I dont specify the column name for the table 'product' it still gives me the same result as when used any of the field (Product[color],Product[name]) on the table? how does this logic works? please can someone explain it to me please?

ex:

calculate ( sum (sales[TotalAmount],Product)

calculate ( sum (sales[TotalAmount],Product[color])--same result as above

calculate ( sum (sales[TotalAmount],Product[name])--same result as above

Thanks in adv