Forum Discussion

Madhans's avatar
Madhans
Frequent Visitor
3 years ago

New Column DAX

Actually what I need is zero in my LOGIC column whenever I meet the below requirements(IN DAX), But if you see in the USD AMOUNT column the 175 data should not be zero in the LOGIC column because ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Madhans 

Please try

 

Logic =
VAR PO = Table1[PO No]
VAR USD = Table1[USD Amount]
VAR T =
    CALCULATETABLE (
        Table1,
        ALLEXCEPT ( Table1, Table1[Month], Table1[PO No], Table1[Account Code ] )
    )
VAR A1 =
    COUNTROWS ( FILTER ( T, Table1[USD Amount] = USD ) )
VAR A2 =
    COUNTROWS ( FILTER ( T, ABS ( Table1[USD Amount] ) = ABS ( USD ) ) )
RETURN
    IF ( PO <> BLANK () && A1 <> A2 && A2 >= 2, 0 )