Forum Discussion

diegotarquino's avatar
diegotarquino
Frequent Visitor
4 years ago
Solved

Identify unique values through time

Hello everybody, I hope you're all fine and in good health.

I haven't been able to achive what I´m looking for: I need to identify which codes are unique for all the the years in analysis, each year. Please allow me to clarify: let´s consider the first code (highligthed in yellow), I´ve put a mark (1) to show the year where the code appears, whereas a blank space means the code doesn´t appear in that year. In this case it only appears in 2019, meaning it´s unique AND is located in 2019.

The second code, for example, appears in 2019, 2020 and 2021, so it´s not unique. The third code from the bottom up only appear in 2021, so it´s unique AND is located in 2021.

Under this reasoning, I need to identify, for each year, those codes that are unique throught all 3 years. Maybe a measure would help here, something like filtering the codes by year AND by "unique", I´m not sure.

 

Thanks in advance for your help.

 

Diego 

 

Need Help
  • davehus's avatar
    davehus
    4 years ago

    Hi diegotarquino ,

     

    See if the attached is what you need.

     

    There is a measure that counts the distinct records per year and then a second one counts the unique records, so 1 occurrence in 3 years.

     

    Did I help you today? Please accept my solution and hit the Kudos button.

     

     

     

     

8 Replies