Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DISTINCT count for first value DAX

Help me to create the calculated column for the DISTINCT count for first value DAX   if id repeats multiple time we have to consider as 1   ID Result 69260 1 69260 0 69260 0 69...
Need Help
Tutorial Requests
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    At first, you need to add an index column in the query editor.

    Then you could create a new column to get the result.

    Column =
VAR a =
    CALCULATE (
        FIRSTNONBLANK ( 'Table'[ID], 1 ),
        FILTER ( 'Table', 'Table'[Index] = EARLIER ( 'Table'[Index] ) - 1 )
    )
RETURN
    IF ( a = 'Table'[ID], 0, 1 )

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Distinct count function is there for this

https://docs.microsoft.com/en-us/dax/distinctcount-function-dax

 

M1= distinctcount(ID)

M1= Calculate (distinctcount(ID))

 

Have I missed something?

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Anonymous's avatar
Anonymous
Not applicable
6 years ago

it's giving the sum total ID or 1 value. or it's not ignoring the second value