I am trying to do a DISTINCTCOUNT of client reference numbers in a table, but I want to combine the results of two separate filters (to be applied on an "Or" basis).
Here are the two separate MEASURES:
=CALCULATE(DISTINCTCOUNT(Table1[PulseReferenceNumber]),'Table1'[SurplusDeficit]>50)
=CALCULATE(DISTINCTCOUNT(Table1[PulseReferenceNumber]),'Table1'[DebtBalance]>20000)
I would like a single DISTINCTCOUNT measure that combines the two above on an "Or" basis, is that makes sense!
Many thanks in advance for any help.
Here are the two separate MEASURES:
=CALCULATE(DISTINCTCOUNT(Table1[PulseReferenceNumber]),'Table1'[SurplusDeficit]>50)
=CALCULATE(DISTINCTCOUNT(Table1[PulseReferenceNumber]),'Table1'[DebtBalance]>20000)
I would like a single DISTINCTCOUNT measure that combines the two above on an "Or" basis, is that makes sense!
Many thanks in advance for any help.