Have only certain items show that meet a threshold

[Jpahl2033]

hi,

I was curious if it possible to create a report where the only items that show up that meet a certain threshold when the data is refreshed. I have provided a small sample set for reference along with a example below. 

	7/20/2022	7/21/2022	7/22/2022	7/23/2022	7/24/2022	7/25/2022	7/26/2022	7/27/2022	7/28/2022
Item A	3	10	14	3	2	3	15	2	3
Item B	3	4	5	21	2	2	15	2	2
Item C	4	10	12	12	2	2	2	2	2

So i have 3 items that i want to put into a table. The threshold is 2 item difference from the day before. The data will refresh for the day before. How do i get it where let's say on 7/24/2022 the data is loaded for 7/23/2022, only item A & B show up and not Item A? Another example is on 7/27/2022 data is loaded for 7/26/2022 only Item A & Item B show up in the table? Or really any way to showcase in the table that the threshold was met. 

Let me know if you have any questions or comments. Happy to explain more! 

[Jpahl2033]

Thank you very much. This worked! 

[v-cgao-msft · Accepted solution]

Hi @Jpahl2033 ,

My idea is to mark out these values using conditional formatting.

Please try this measure:

Colour = 
VAR _date =
    MAX ( 'Table'[Date] )
VAR _p_date = _date - 1
VAR _value1 = [Measure]
VAR _value2 =
    CALCULATE (
        [Measure],
        'Table'[Date] = _p_date,
        ALLEXCEPT ( 'Table', 'Table'[Item] )
    )
VAR _result =
    IF ( ABS ( _value1 - _value2 ) >= 2 && _value2 <> BLANK (), "red" )
RETURN
    _result

Application Condition Format:

Result:

The PBIX file is attached for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Jpahl2033]

Hi @v-cgao-msft ,

your solution worked! I did have a follow up. Using the table in the original post, lets say I am grouping days  so for instance, the first 3 days are week 1, the next 3 days are week 2, the last 3 days are week 3. Is there a week to tweak your solution above to have a weekly variance threshold?

Thanks!