Forum Discussion

py1029's avatar
py1029
Frequent Visitor
4 years ago
Solved

Remove Duplicate using Dax

Hi,   I have a slicer which I can select the plant name. For instance, when I select one of the plant name (Bukit Jalil), it has the following outcome. When I select another plant name (Ampa...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Please add an index column in query editor then create measure like below and apply it to visual level filter:

    Measure = RANKX(ALLSELECTED('Table'[Plant Name]),CALCULATE(MAX('Table'[Index])))

     

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Please add an index column in query editor then create measure like below and apply it to visual level filter:

Measure = RANKX(ALLSELECTED('Table'[Plant Name]),CALCULATE(MAX('Table'[Index])))