Joining two variables to get correct row and column totals

[A_a_a]

Hi All,

I created a measure with two variables, which should provide correct totals for rows and for columns in Matrix Table.

Rows show products(dim_a [a]), Columns show weeks (dim_b[b]).

When I use ‘var a’, it works correctly for column total, if ‘var b’ for row total.

I have no idea how to join them in Return to see correct totals in rows and columns at the same time.

Measure =

var a =CALCULATE(IF(COUNTROWS(VALUES(dim_a[a]))=1,[Measure V1],sumx(values(dim_a[a]),[Measure V1])))

var b = CALCULATE(IF(COUNTROWS(VALUES(dim_b[b]))=1,[Measure V1],sumx(values(dim_b[b]),[Measure V1])))

Return ??

Please support. Thank you.

[amitchandak]

@A_a_a , Try like

Measure =

var a= sumx(filter(values(dim_a[a]),COUNTROWS(VALUES(dim_a[a]))=1 ),[Measure V1])
var b= sumx(filter(values(dim_b[b]),COUNTROWS(VALUES(dim_b[b]))=1 ),[Measure V1])

return
a+b

[A_a_a]

Hi @amitchandak 

Thank you.

Unfortunately, it is not working.