Calculate and Filter question

[Anonymous]

Hello

The four measures below are calculating the total for the same product. 2 are filtering on the ProductID and 2 on the ProductName.

2 are using the FILTER function in calculate and 2 are using the calculate built in filter

When I add all 4 to a PBI report and a slicer only c is ignoring the filter context?

My question is why isn’t the first function (a) always returning the value and ignoring the filter?

 The only one that is c

EVALUATE
ROW ( "a", CALCULATE ( SUM ( SalesFact[Revenue] ), product[ProductID] = 92 ) )--> Expect it to Always returns total value for Product

EVALUATE
ROW (
    "b", CALCULATE (
        SUM ( SalesFact[Revenue] ),
        FILTER ( 'Product', product[ProductID] = 92 )
    )
)

EVALUATE
ROW ( "c", CALCULATE ( SUM ( SalesFact[Revenue] ), 'Product'[Product]="Abbas UM-19" ) )--> Always returns total value for Product

EVALUATE
ROW (
    "d", CALCULATE (
        SUM ( SalesFact[Revenue] ),
        FILTER (  'Product',  'Product'[Product]="Abbas UM-19" )
    )
)

Thank in advance.

[lbendlin]

This may help.

https://www.sqlbi.com/articles/context-transition-and-filters-in-calculate/

[Anonymous]

Ibendlin

Thanks for the reply and the link, I think I understand the context transition but I'm still not sure why filters from the same table are producing different results? Why dose the field I filter on matter?

EVALUATE
ROW ( "a", CALCULATE ( SUM ( SalesFact[Revenue] ), 'Product'[ProductID] = 92 ) )

EVALUATE
ROW ( "c", CALCULATE ( SUM ( SalesFact[Revenue] ), 'Product'[Product]="Abbas UM-19" ) )

Thanks again.

[lbendlin]

I am not saying that I understand the article fully but I know the answer is in the article.