Forum Discussion
Measure showing different value in Table vs Card visual
Hi Anonymous ,
Table visual applies row filters (row context), so Power BI filters automatically for each row:
Product = A → 120
Product = B → 350
Product = C → 180
Since card visual has NO row context, It shows the total sum across the entire dataset.
If you want the card to always ignore filters and return one consistent value, create new measure as below
CALCULATE([Total Sales], REMOVEFILTERS())This removes all product-level filters and ensures consistent results across visuals.
Thanks
Hi Anonymous ,
Table visual applies row filters (row context), so Power BI filters automatically for each row:
Product = A → 120
Product = B → 350
Product = C → 180
Since card visual has NO row context, It shows the total sum across the entire dataset.
If you want the card to always ignore filters and return one consistent value, create new measure as below
This removes all product-level filters and ensures consistent results across visuals.
Thanks
Anonymous Abhilash_P
Great explanation overall! Just wanted to mention that what you're describing is actually filter context, not row context.
Filter context is what's happening here. The Table visual applies filters for each row (Product A, B, C), while the Card has no filters applied. Row context is different and typically occurs in calculated columns or iterator functions like SUMX, where DAX evaluates row by row within a table.
In this case, the Table visual creates a filter context for each product, and the Card visual shows the total because there's no filter context limiting it.
Hope it helps!