Measure showing different value in Table vs Card visual

[Sherwin_13]

Hi Everyone,

I’m facing an issue where thesame measure shows different results in a Table visual vs a Card visual, and I’m not able to understand.

Here is my sample data:

Product	Sales Amount
A	120
B	350
C	180

I created a simple measure:

Total Sales = SUM(Sales[SalesAmount])

In a Table (with Product column):

Product	Total Sales
A	120
B	350
C	180

These numbers are correct.

But in a Card visual, the same measure shows:650

Which is the sum of all products:
120 + 350 + 180 = 650

How can I make the measure behave consistently?

[ryan_mayu]

what does 180 stands for? I think 650 is correct. What's the expected output?

if you want to show a product, you can try below

Total Sales Product A = CALCULATE(SUM(Sales[SalesAmount]), Sales[Product] = "A")

[Kedar_Pande]

@Sherwin_13 

This is expected behavior - not a bug.

Table visual: Shows measure per row context (filtered by Product)

A: 120, B: 350, C: 180

Card visual: Shows measure in total context (no Product filter)

All products: 650

Your measure is working correctly.

If this answer helped, please click Kudos or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

[Abhilash_P · Accepted solution]

Hi  @Sherwin_13 ,
 

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

[alish_b]

@Sherwin_13  @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!