Forum Discussion

Palmtop's avatar
Palmtop
Icon for Helper I rankHelper I
3 years ago
Solved

SUMX Different Column Depending On IF Condition

Hello All,   I am struggling with a measure that is trying to accomplish the following:   I have a set of ID_Tasks attributed to ID_Project and I want to find the TotalSales by summing either Tot...
DAX SUMX
Help Requested
  • tamerj1's avatar
    tamerj1
    3 years ago

    Palmtop 
    Sorry fo the late response. The problem is coming from the ALLSELECTED in the Duplicate measure. This has to be done manually.

    Total Sales = 
VAR SelectedTable = ALLSELECTED ( SalesProfiles )
RETURN
    SUMX ( 
        SUMMARIZE ( SalesProfiles, ProjetList[ID_Project], ProjetList[ID_Task] ),
        IF (
            CALCULATE ( 
                COUNT ( SalesProfiles[ID_Project] ), 
                SelectedTable, 
                VALUES ( SalesProfiles[ID_Project] ) 
            ) = 1,
            SUM ( SalesProfiles[TotalSalesSingle] ), 
            SUM ( SalesProfiles[TotalSalesMulti] )
        )
    )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Palmtop 
Sorry fo the late response. The problem is coming from the ALLSELECTED in the Duplicate measure. This has to be done manually.

Total Sales = 
VAR SelectedTable = ALLSELECTED ( SalesProfiles )
RETURN
    SUMX ( 
        SUMMARIZE ( SalesProfiles, ProjetList[ID_Project], ProjetList[ID_Task] ),
        IF (
            CALCULATE ( 
                COUNT ( SalesProfiles[ID_Project] ), 
                SelectedTable, 
                VALUES ( SalesProfiles[ID_Project] ) 
            ) = 1,
            SUM ( SalesProfiles[TotalSalesSingle] ), 
            SUM ( SalesProfiles[TotalSalesMulti] )
        )
    )
  • Palmtop's avatar
    Palmtop
    Icon for Helper I rankHelper I
    3 years ago

    Hi tamerj1 , 

     

    Not at all!! Happy to say that it works just like needed and I'm learning a lot along the way.  Thanks so much for your patience and help!