Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

remove duplicate based on specific value

I have data as shown belew    id stage status 1 a complete 1 b complete 1 b not complete 2 a complete 2 b not complete   I want to drop the duplicate rows based o...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    I've created this file as an example: Download PBIX 

     

    Ricardo

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Anonymous ,

 

Please, if it worked mark this as a solution. So we can help other with the same question.

 

Thanks.

 

Ricardo

Anonymous's avatar
Anonymous
Not applicable
6 years ago

thank you it worked but is there any way to apply it with measure

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    Hi Anonymous ,

     

    Yes,

     

    try this code:

     

    Measure =
    VAR _qtdeStatus = CALCULATE(DISTINCTCOUNT('Table (2)'[status]); ALLEXCEPT('Table (2)'; 'Table (2)'[id]; 'Table (2)'[stage]))
    RETURN IF(_qtdeStatus > 1; CALCULATE(DISTINCT('Table (2)'[status]); FILTER('Table (2)'; 'Table (2)'[status] = "Complete")); CALCULATE(DISTINCT('Table (2)'[status])))
     
    Ricardo