Forum Discussion
DISTINCTCOUNT excluding certain records
Hello. I need some help. Below is an example of my model: I am trying to get a count of all transactions with a First Transaction Date before 01/02/2022 (based on slicer selection) u...
Hi Anonymous
Please try= CALCULATE ( DISTINCTCOUNT ( 'Transaction Table'[Rreference] ), 'Transaction Table'[First Transaction Date] < MIN ( 'Date Table'[Date] ), CROSSFILTER ( 'Transaction Table'[Transaction Date], 'Date Table'[Date], NONE ) )
tamerj1
Community Champion
Community ChampionHi Anonymous
Please try
=
CALCULATE (
DISTINCTCOUNT ( 'Transaction Table'[Rreference] ),
'Transaction Table'[First Transaction Date] < MIN ( 'Date Table'[Date] ),
CROSSFILTER ( 'Transaction Table'[Transaction Date], 'Date Table'[Date], NONE )
)