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...
  • 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.

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.