Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate and Filter question

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.

CALCULATE
Filter

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        lbendlin
        Icon for Super User rankSuper User
        6 years ago

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