Forum Discussion

mohan_g_das1986's avatar
mohan_g_das1986
Helper III
4 years ago

How show difference in Distinct Count

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/20226/2/2022Difference
ProgramCommercialRetailCommercialRetailCommercialRetail
Program1533122
Program261521-1
Program32051-3-1

 

Please I need some urgent support on this

Need Help

2 Replies

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    4 years ago

    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.