Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
I am not saying that I understand the article fully but I know the answer is in the article.