DAX sum issue

al1ceDav1n — Tue, 22 Aug 2023 14:19:18 GMT

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

Re: DAX sum issue

Anonymous — Thu, 24 Aug 2023 02:41:30 GMT

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.

topic Re: DAX sum issue in DAX Commands and Tips

DAX sum issue

Re: DAX sum issue