Using distinctcount on summed rows

[hpandersen]

Hi.

I have a tabel with a lot of customer financial transactions.
One customer can easily have 100 transactions per year.
Example:

Customer	Year	Amount
101	2018	250
101	2018	500
101	2018	300
102	2018	800
102	2018	300
102	2018	700
103	2018	600
103	2018	200
103	2018	100

<tbody>
</tbody>

I would like to sum the different transaction per customer per year and the count how many of these summed transaction amount is >1500
In this excample, the sum amount for customer 102 is 1800 and should be counted as one.

I have made this counting in a pivot in Excel, but I really can't figure out how to do it in Power BI.
Any suggestions?

 

[mrshl9898]

Hi,

For BI, i'd add a measure AmountSum = CALCULATE(SUM(Tablename[Amount]),Tablename[Year])

Have Customer and Year in a table, and have a visual level filter on AmountSum > 1500

 

[mrshl9898]

That measure isn't quite right. But you need to sum the amount for the customer and the year.