Filtered Count Assistance

[jmayer96]

Hi there!

Been struggling with this for a bit, I have a balance in one field, and have created a conditional field to age the balance, when I pull distinct counts it will give me a correct total, but not per aging group. Since the accounts have a balance in multiple rows I'm not sure how to proceed.

I created 4 more conditional columns that come to 0 if its it not one of the other buckets, but the count still somehow is the same as before.

What I'm looking for are distinct counts, with customers who only have a balance in either of these 4 columns:

What I get now is this:

584,845 is the correct distinct total, but obviously there are customers double counted in the other buckets, so they will never equal the correct total.

Thanks!

[amitchandak]

@jmayer96 , Try a measure like

calculate(distinctcount(Table[Customer]), filter(Table, Table[Arrear_bal_1_30] >0 || Table[Arrear_bal_31_60] >0 || Table[Arrear_bal_61_90] >0 || Table[Arrear_bal_90+] >0))