How to show both selected value in the slicer, and the unselected value

[wen2z]

Hello Everyone.

I have difficulty on my Power BI.

I want to show the total amount from the Sales Table below.

Order Number	Item	Amount
1	A	100
2	B	200
3	C	300
4	D	400

When I filtered it using slicer by order number, the SUM amount that filtered is correct.

The problem is, how to show the Unchecked SUM amount in Card visual on the dashboard??

Eg : i checked only 1,2,3 Thus result the sum amount 100+200+300 = 600
i want to display the difference : 4 = 400.

[Dangar332]

hi, @wen2z 

Try below measure

orsum =

var a = CALCULATE(SUM('order'[amount]),ALLEXCEPT('order','order'[amount]))

var b = SUM('order'[amount])

return ABS(a-b)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

[wen2z]

Hello Dangar, thank you for your feedback.

The measure works. 

But if I combine it with filter by date

Eg: I have 3 years of data (2020 until 2023), and I filtered only to show 2023.

the unselected amount is shows the SUM from 2020 to 2023 plus the document no that I'm not selected.

[Dangar332]

hi, @wen2z 

use keepfilters inside of var a 

orsum =

var a = CALCULATE(SUM('order'[amount]),ALLEXCEPT('order','order'[amount]),keepfilters('tablename'[datecolumn]))

var b = SUM('order'[amount])

return ABS(a-b)

[Dangar332]

hi, @wen2z 

here you can check

here date table seprate and linked with main table

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.