Do sum of distinct count

[Chandrakala1510]

I need to do sum of ditinctcount function

 DISTINCTCOUNT(table[cate])

and this measure i will use for multiple category of visuals

i found this solution 

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

, but this is not working for me

its very urgent for me can anyone help on this? 

[parry2k]

@Chandrakala1510 you don't have to type in CAPITAL letters. Take it easy. First, why you are summarizing in the first place? Provide full details if you need help. Just sharing DAX doesn't help. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Chandrakala1510]

can reply any one on this issue. this is urgent

[Anonymous · Accepted solution]

Hi @Chandrakala1510 ,

I agree with parry2k, I suggest you to summairze your calculation based on [Status] column. Due to [Status] column is the key column of this visual, so if you want to get correct total, you need to sumx the discount based on [Status] column.

Workaound1: 

UserDistinct = DISTINCTCOUNT ( Table[Name] )

UserDistinct with correct subtotal =
SUMX ( VALUES ( 'Table'[Status] ), [UserDistinct] )

Workaound2: 

User Distinct =
VAR t =
    SUMMARIZE (
        'Table',
        Table[Status],
        "UserDistinct", DISTINCTCOUNT ( Table[Name] )
    )
RETURN
    SUMX ( t, [UserDistinct] )

If this reply still couldn't help solve your issue, please share a sample file with me.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Chandrakala1510 you are grouping by date in the summarize and viewing it by Status, what if you change the grouping to Status and then check it?

[Chandrakala1510]

NO I DONT want to grouping it by any category in measure.

because i want to view it by multiple category

not just STATUS

so need one solution

[parry2k]

@Chandrakala1510 can you share what is not working? How does data look like? What do you want the output to be?

[Chandrakala1510]

here total should be 424 but it is comming 423

because i have used distinct count function DAX

and this 

distinctCount(table[column]) 

i am using in many visuals

so not possible to create 

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

multiple measures for various category

need help

give me solution to create only one DAX for all kind of category solution