DAX Distinct count. Total in table to be sum of distinct counts per row, not total distinct

[Anonymous]

 I want to total for 'count of visitors' to be 4424 as its a unique count.

I tried this but it gives a huge number not even close?

User Distinct =
VAR t =
    SUMMARIZE (
        'Kepler',
        Kepler[Date],
        "UserDistinct", DISTINCTCOUNT ( Kepler[Visitors] )
    )
RETURN
    SUMX ( t, [UserDistinct] )

Any help!

Thanks,

Warren

[Anonymous]

@v-yulgu-msftHello,

I want to sum the "Quantite" but with using the discount for "referenceNo" ?

I've tried : qte = calculate(distinctount(tabel[referenceNo]), filter(table,sum(table[quantite]))). But it doesn't work

How can i do it ?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

You can try this measure:

Measure distinct count visitor =
SUMX (
    VALUES ( Kepler[Date] ),
    CALCULATE ( DISTINCTCOUNT ( Kepler[Visitors] ) )
)

Best regards,

Yuliana Gu

[anasf]

Thanks for this!! It works but I am not sure why/how 😅 Just to build on the above, if I wanted to limit to the last 7 days, previous 7 days etc. how would I be able to do that?  

[rkrishang]

Amazing Solution @v-yulgu-msft  !! Thanks so much !!

[Anonymous]

Thankyou Yuliana. That's perfect!

[Greg_Deckler]

Need sample source data in text form that can be copied and pasted. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490