matrix column total in card visual not matching?

[PowerBITesting]

For Total of a column like salary I have added a card visual with a dax sumslary = Sumx(table[salary]) but the results are not matching as I have filters and slicers are added to the Matrix

Note: all filters are page level which applies to both card and matrix.

name || Salary || age

Test      12           4

[v-easonf-msft]

Hi, @PowerBITesting 

Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi, @PowerBITesting 

The measure will be affected by the current context in the matrix.

For the wrong value in  a card visual ,you need use function "summarize" to generate a temporary table then calculate the value  in a measure .
E.g:

Measure1 =
SUMX (
    FILTER (
        SUMMARIZE (
            table,
            table[Year],
            table[Department],
            table[salary],
            "measure", SUMX ( table, table[salary] )
        ),
        table[Year] = 2013&&table[Department]="Department A"
    ),
    [measure]
)

Apply your own measure to your card visual .

Best Regards,
Community Support Team _ Eason

[amitchandak]

@PowerBITesting , I hope you create a measure like

Sumx(table, table[salary]), This seems fine.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.