I've created two slicers for Brand and Order and a visual table with these columns: Brand, Color, SumQuantity. With this table, I expect to see the same SumQuantity of different colors products with the same Brand in all circumstances. But when I choose BrandDell & HP and Order1 & 2 on the slicers, the result is shown as follows:
Notice the SumQuantity of HP-Blue products is 13 while HP-Black/HP-Red is 20; the SumQuantity of Dell-Black is 6 while Dell-Blue is 18.
When I filters BrandHP and Order1 & 2 in Excel, the sum quantity is 20 so the SumQuantity of HP-Black/HP-Red rows are as expected while HP-Blue is not. I've tried to replicate the result of HP-Blue and found out Power BI is working like so:
- Applying all filters and contexts (BrandHP and ColorBlue)
- With that, it finds that only Order2 has HP-Blue products. Then it removes filter on column Color with filters Order2 and BrandHP applied, and calculates the result SumQuantity is 13.
When I use the same measure replaced ALL funtion with ALLSELECTED, the result is as expected: