Solved! Go to Solution.
Your dataset consists of three rows and you have no rows with both Apple AND Electric. Filter context is accumulative and applies a logical AND, so only rows that meet every condition will be returned to the COUNT function.
as you said,if the filter context is accumulative, then the left measure test1 's outer filter context is same with the red box on the right,which stimulates test3 's pivot environment.
although "apple, electric" return no rows, test1 's filter context was overwrite to "tv , electric" by inner filter context. why this can happens on test1 , not test3, I‘m a bit confused
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!