Forum Discussion

al1ceDav1n's avatar
al1ceDav1n
Regular Visitor
3 years ago
Solved

DAX sum issue

Hi I am working in DAX Studio and have a column in my model that consist of 

 

Failure to deliver cash Settlement fails value = SWITCH( TRUE(), [TYA-QRY] = 0 && [Date] = {EFF_PLI_DV} && [FTY_RSN_ID] = "CASH", 0, 

[STH_SPL_CD] = "FAND"" && [Date] = [SFL_HUS_DATE] && [FTY_RSN_ID] = "CASH" ,0,  [FTY_RSN_ID] <> "CASH" ,0, [FAD_EUR]

 

works perfect in power bi 

 

However I need to sum this in DAX and having issues 

 

Tried 

Failure to deliver cash Settlement fails value = SUM([Failure to deliver cash Settlement fails value]) but still not summing any ideas please 

 

Thanks loads

Ally

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi al1ceDav1n ,

     

    According to your statement, [Failure to deliver cash Settlement fails value] is a measure created by SWITCH function.

    I think you want to show correct subtotal in your visual.

    As far as I know, we need to use measure in a visual. There should be some key columns like "ID"/"Country"/... in your visual and the measure will return result based on these key columns. I suggest you to sum the measure based on these key columns.

    Switch with correct total =
SUMX (
    SUMMARIZE ( 'TableName', 'TableName'[KeyColumn1], 'TableName'[KeyColumn2],... ),
    [Failure to deliver cash Settlement fails value]
)

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi al1ceDav1n ,

     

    According to your statement, [Failure to deliver cash Settlement fails value] is a measure created by SWITCH function.

    I think you want to show correct subtotal in your visual.

    As far as I know, we need to use measure in a visual. There should be some key columns like "ID"/"Country"/... in your visual and the measure will return result based on these key columns. I suggest you to sum the measure based on these key columns.

    Switch with correct total =
SUMX (
    SUMMARIZE ( 'TableName', 'TableName'[KeyColumn1], 'TableName'[KeyColumn2],... ),
    [Failure to deliver cash Settlement fails value]
)

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.