Get list of IDs in red

[Anonymous]

Hi all,

I have matrix table with dates, IDs and values.
Have created measure that compares values for each previous date and if the value changed more than 50%, I mark it as 1
In the matrix table for each field that has a value - 1  from the measure, it is colored red.
I want to create slicer for those who have value 1 from measure.
Tried to put measure in slicer, tried to filter by measure but did not work.

Flag measure = 
VAR currentvalue = [valueRate]
VAR previousvalue =
    CALCULATE ([valueRate], table1[test_date] = MAX (table1[test_date]) - 1)
VAR comparisonvalue = (currentvalue - previousvalue) * (100/previousvalue)
RETURN
    IF (
        currentvalue <> BLANK ()
            && previousvalue <> BLANK (),
        SWITCH (
            TRUE (),
            comparisonvalue <= -50, 1
        )
    )

Any advice? 
In best case is there any way to display IDs directley from measure and just get devices if they ever had value 1 from measure?

Thanks!

[v-easonf-msft]

Hi， @Anonymous 

Not fully sure what you want.

Pleae check if field parameters can help.

Best Regards,
Community Support Team _ Eason

[MFelix]

Hi @Anonymous,

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.