Forum Discussion

nanutum's avatar
nanutum
Helper I
6 years ago

IF in Measure Why Total not sum

Hi all

i create measue use "IF"  Results is OK but Total not show 

 

Lost Customer Code 

 

 

Lost_Customer = 
    IF(AND([Bought_P1]<> BLANK (),[Bought_P2] = BLANK ()),
        DISTINCTCOUNT(Cust[Cust_Code]),
            BLANK()
    )

 

 

New Customer Code

 

New_Customer = 
        IF(AND([Bought_P1] = BLANK(),[Bought_P2] <> BLANK ()),
            DISTINCTCOUNT(Cust[Cust_Code]),
                BLANK()
        )

 

 

please help me . Thankyou 

 

Need Help
Tips and Tricks

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    6 years ago

    Please try this approach, referencing your existing measure in a new measure to use in its place.  Replace Table[Customer] with the customer column used in your visual.

     

    NewMeasure = SUMX(VALUES(Table[Customer]), [Lost_Customer])

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

    • nanutum's avatar
      nanutum
      Helper I
      6 years ago

      Dear mahoneypat 

       

      MY Measure 

      Lost_Customer = 
    IF(AND([Bought_P1]<> BLANK (),[Bought_P2] = BLANK ()),
        DISTINCTCOUNT(Cust[Cust_Code]),
            BLANK()
    )

      Your Measure 

      NewMeasure = SUMX(VALUES(Table[Customer]), [Lost_Customer])

       

      i need have only one measure i try this but Data not show

      Lost_Cust_01 = 
var _Lost_Cust = IF(AND([Bought_P1]<> BLANK (),[Bought_P2] = BLANK ()),
                    DISTINCTCOUNT(Cust[Cust_Code]),
                        BLANK()
                )
Return 
        SUMX(VALUES(Cust[Cust_Code]),_Lost_Cust)

      please help me again