i have the below DAX query
EVALUATE
SELECTCOLUMNS (
ADDCOLUMNS (
FILTER (
CROSSJOIN ( ALL ( Company[Country] ), ALL ( 'Date'[year] ) ),
'Company'[Country] IN { "US", "CA" } && 'Date'[year] = "FY2022"
),
"Sum", CALCULATE ( 'Total'[sum] ),
),
"SUM", [Sum]
)i am getting the below two rows of output.
SUM
1234
5678
my objective is to return a single row with the total sum of “US” and “CA”.
Does anyone know,how can i do it in a simple with the above code?
Thanks in advance