How show difference in Distinct Count

Hi,

I suspect you have not shared all your requirements, I guess your end users want to filter on period, and see the change over that period. It will depend on your modell, but given your description, I have created a mockup report, and created this measure

Measure =
VAR _minDate =
    MIN ( 'Table'[date] )
VAR _maxDate =
    MAX ( 'Table'[date] )
VAR _minDateValue =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( ALL ( 'Table'[date] ), 'Table'[date] = _minDate )
    )
VAR _maxDateValue =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( ALL ( 'Table'[date] ), 'Table'[date] = _maxDate )
    )
RETURN
    IF (
        HASONEVALUE ( 'Table'[date] ),
        COUNTROWS ( 'Table' ),
        _maxDateValue - _minDateValue
    )

which will show the difference in the total column, and rename the total label to difference:

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.