Question about IF() & filter context, Maybe~

[Anonymous]

Hi community
I’m sorry .
In fact, I don’t know how to describe my question.
So ,let me use the screenshot to ask my question ~

1. Relationship

2.Measure (In these measures ,I did not use the calendar table.)

SumSalesValue = SUM('Order'[SalesValue])

2011SalesValue = CALCULATE([SumSalesValue],FILTER(‘Order’,YEAR(‘Order’[OrderDate]) = 2011 ))

2012SalesValue = CALCULATE([SumSalesValue],FILTER(‘Order’,YEAR(‘Order’[OrderDate]) = 2012 ))


Trend2011v2012 = 
IF( [2011SalesValue] <= 0 && [2012SalesValue] >  0 , “New”,
    IF( [2011SalesValue] > 0  && [2012SalesValue] <= 0 , “Lost”,
        IF( [2011SalesValue] > 0  && [2012SalesValue] > 0  &&  [2011SalesValue] > [2012SalesValue] , “DEC”,
            IF( [2011SalesValue] > 0  && [2012SalesValue] > 0  &&  ([2011SalesValue] < [2012SalesValue]) , “INC” , “STD “)
            )
        )
    )

3. Visual Table (Yes, the screenshot as below is my question .)
Why is there a Cartesian product in this table?

[v-frfei-msft]

Hi @Anonymous ,

Why did you add two CustomerID columns from different tables into one visual? Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

Regards,

Frank