DISTINCTCOUNT with a measure greater than 0

[Anonymous]

I am trying to count the number of different IDs that have a balance greater than 0. The total due is a meausre i have already created. 

This is the formula i have been trying to work with...

Count ID = CALCULATE(DISTINCTCOUNT(Invoice[Customerid]),[Total Due] > 0)

The measure to calculate that balance, or Total Due is this

Total Due = SUM('Invoice Detail'[Trx_amount])-SUM('Invoice Detail'[Trx_totalpaid])

Thanks!

[MFelix · Accepted solution]

Hi @Anonymous ,

You need to add a filter to your measure in order to make it work.

Redo your measure like this:

Count ID =
CALCULATE (
    DISTINCTCOUNT ( Invoice[Customerid] );
    FILTER ( ALL ( Invoice[InvoiceID] ); [Total Due] > 0 )
)

should work as expected

Regards,

MFelix

[purpleme_fin]

@MFelix had an almost similar problem.
tried some genius moves there with long DAX coding, and got really irritated.

To cut it short. Thanks man, the solution worked like a charm for me.