how to show only items that have had a status change

[Steph83]

Hello community,

I have a list of Vessels attributed to a Fleet. Each month, I am recording the status.

I have several years of records and hundred of vessels.

I would like to display only the vessels which have had fleet changes

For example, I have 4 vessels, 2 of them have had fleet changes:

01/05/2022	IGLOO	Fleet A
01/06/2022	IGLOO	Fleet A
01/07/2022	IGLOO	Fleet A
01/05/2022	CAPTAIN LEON	Fleet A
01/06/2022	CAPTAIN LEON	Fleet A
01/07/2022	CAPTAIN LEON	Fleet B
01/05/2022	SWEET	Fleet C
01/06/2022	SWEET	Fleet C
01/07/2022	SWEET	Fleet C
01/05/2022	UNICORN	Fleet B
01/06/2022	UNICORN	Fleet C
01/05/2022	UNICORN	Fleet C

I would like to display:

DateCategoryStore

01/05/2022	CAPTAIN LEON	Fleet A
01/06/2022	CAPTAIN LEON	Fleet A
01/07/2022	CAPTAIN LEON	Fleet B
01/05/2022	UNICORN	Fleet B
01/06/2022	UNICORN	Fleet C
01/05/2022	UNICORN	Fleet C

I thank you in advance for your help!

[jdbuchanan71 · Accepted solution]

@Steph83 

A measure like this will count the number of category / store combinations.

Filter Measure = 
VAR _CategoryStore = 
    CALCULATETABLE(
        SUMMARIZE(
            'Table',
            'Table'[Category],
            'Table'[Store]
        ),
        ALLEXCEPT('Table','Table'[Category]))
RETURN
    COUNTROWS(_CategoryStore)

Then we can apply that as filter to the table:

[Steph83]

@jdbuchanan71 

Hi, thank you that's perfect.