How show difference in Distinct Count

[mohan_g_das1986]

Hi,

I have a measure for distinct partners using Partner id from my partner's table for 2 days (6/1/2022 and 6/2/2022)

# of partners = distinctcount(Partner id)

Used another column to show the visual for 2 days.

My customers wanted what is the difference between these 2 days - how much is increased for a category A, B, C & D

	6/1/2022	6/2/2022	Difference
Program	Commercial	Retail	Commercial	Retail	Commercial	Retail
Program1	5	3	3	1	2	2
Program2	6	1	5	2	1	-1
Program3	2	0	5	1	-3	-1

Please I need some urgent support on this

[Anonymous]

Hi @mohan_g_das1986 ,

I can't combine the table you shared with the description of your requirement.

Please share some sample data and expected result.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

Best Regards,

Jay

[sturlaws]

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.