Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Remove duplicates in DAX

Hi Guys,   Edit: Proving more informations   I have this two different tables, the fact table (many ids) and my time table (unique id) TABLE 1 FACT  TimeID ID start time finish time 1 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

danextian's avatar
danextian
Icon for Super User rankSuper User
5 years ago

hI Anonymous ,
You can try this formula to be used as a visual filter where value = 1

FirstValue =
IF (
    SELECTEDVALUE ( 'FACT'[start time] )
        = CALCULATE ( MIN ( 'FACT'[start time] ), ALLEXCEPT ( 'FACT', 'FACT'[ID] ) ),
    1,
    0
)