Forum Discussion

bwelsh's avatar
bwelsh
Helper I
9 years ago
Solved

DAX Calculated Table

I'm trying to create a calculated table based on a table with a colum for USER ID and EVENT ID (among others).   I need to create a table showsing disting USER ID's for only specific EVENT ID's.  ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi bwelsh,

    Please use the formula below to create new table.

    CALCULATED TABLE = DISTINCT( SELECTCOLUMNS(FILTER('Original Table', 'Original Table'[EVENTID] = "SPECIFIC EVENT ID"),"EVENTID",'Original Table'[EVENTID],"SPECIFIC EVENT ID",'Original Table'[SPECIFIC EVENT ID]))


    Best Regards,
    Angelia

bwelsh's avatar
bwelsh
Helper I
9 years ago

Wouldnt this modify the original table though? 

 

I'm trying to create a seperate table.

parry2k's avatar
parry2k
Super User
9 years ago

you can make duplicate of original table and then do the distinct on that, right click on original table and click "duplicate"