DAX sum issue

[al1ceDav1n]

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 · Accepted solution]

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.