SUM BKG No but Distinct if there are Duplicate of BKG No

[Anonymous]

Hi Team

Its me again

almost similiar with prev question

i had table of BKG No

common SUM result RED Column
i want result in Green Column

Pls help me In Dax .

( write me DAX , so i can sopy it )

i still confuse of using it

Thanks and really appreciate any help and respond

Regards

Syaiful Efendi

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create a measure

Measure = DISTINCTCOUNT('Table'[No Booking])

If there is another column added into the table visual, you can create measures

rank =
RANKX (
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[No Booking]
            = MAX ( 'Table'[No Booking] )
    ),
    CALCULATE (
        MAX ( 'Table'[Index] )
    ),
    ,
    ASC,
    DENSE
)

Measure 2 =
IF (
    [rank] = 1,
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[No Booking] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[No Booking]
                = MAX ( 'Table'[No Booking] )
        )
    )
)


Measure 3 = IF(ISINSCOPE('Table'[No Booking]),[Measure 2],SUMX(ALLSELECTED('Table'),[Measure 2]))

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pceglie]

Hi @Anonymous , in dax you can create a table starting from your original table grouping by "No Booking" column.

Hope it will help you.

P.

[Anonymous]

show me in dax pls