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 ()), DISTINCTC...
Need Help
Tips and Tricks
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