The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
34 | |
21 | |
18 | |
15 |
User | Count |
---|---|
124 | |
39 | |
30 | |
24 | |
22 |