How to flag a product based on the value of 2 measures

[Bjorn_80]

Hello, 

I need to flag a product as "non-recurrent" if it has no sales in 2 different timeperiods. 

This is the AS IS : 

* I have a flat table containing products, a customer, an order date and sales amount

* using an inactive relationship I amanged to compare the sales of 2 periodes using 2 measures = SalesPeriod1 and SalesPeriod2 (each period is defined by a slicer - for instance Periode 1 = Q1 2023, Period 2 = Q1 2022 

My questions : 

1. I would like to "tagg" each line in my report where the sales of period 1 or 2 is zero (if that is possible)

2. create  a measure that only return de PQ_Variance_Sales of the sales in period 1 or 2 is zero 

--> in the above screenshot this would result that the yellow amount would staty, and the red underlined amount would be zero 

Thanks for the support and/or advice 

Regards

Bjorn 

[Greg_Deckler]

@Bjorn_80 You can create a "Flag" column using something like a Complex Selector. The Complex Selector - Microsoft Power BI Community