Formula for DistinctCount Voucher where Payment is greater or less than 0

[jonnyA]

Hello,

Hoping someone could help me create the following formula where ...

DistinctCount Voucher where Payment is greater or less than 0

Thank you!

[jonnyA]

@TheoC 

Power BI not liking the formula where I highlighted.  Any ideas on how to fix?

[TheoC · Accepted solution]

Can you try removing the "FILTER (" and just add one ")" at the end?

Sorry, on phone and syntax may be wrong on my part! Apologies. 

[TheoC]

Hi @jonnyA, can you try something like the following?

Measure = 

VAR _1 = DISTINCTCOUNT ( Table[Voucher] )

VAR _2 = CALCULATE ( _1 , FILTER ( Table[Payment] <> 0 ) )

RETURN 

_2