Group aggregated data using date slicer

[herbemischung]

Hi,

I tried to get a solution here: https://community.powerbi.com/t5/Desktop/Remove-0-from-balance-list/m-p/1150852

But I try to reframe:

Is it possible to create something like a group by that can be altered by a slicer?

Let me show you the table [Daten]

date	account no	value	text
01.01.2020	1001	-50	invoice 01
02.01.2020	1002	-70	invoice 02
02.01.2020	1003	-20	invoice 03
05.01.2020	1001	50	payment …
05.01.2020	1002	65	payment …
07.01.2020	1003	10	payment …

It is easy to get the balance list:

account no	Saldo (sum of value)
1001	0
1002	5
1003	10

But I need to get rid of all account numbers that have a "saldo" of 0.

A filter is of no use because on row level, there is no 0

So I thought it would be helpful if there was a possibility to create a virtual table where all values are grouped by account number. 

And if I change the selected date (slicer) the grouping also changes.

It would be easy to create a grouped table, but I want to know the "saldo" in a specific time period. (2019, 2020, 1-5 2020... )

do you think this is possible?

thanks a lot!

[parry2k · Accepted solution]

@herbemischung add another measure that will filter out the zeros

No Zero Measure = 
SUMX ( VALUES ( Table[Account] ), IF ( [Sum Amount Measure] > 0, [Sum Amount Measure] ) )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[herbemischung]

Thanks, it worked. 

In my case there where some account numbers with a "saldo" of 0,00000002 (I really don't know how that is even possible... ), 

thats why nothing worked!