[PowerBi] How to get grand total in cluster column

[MinhPham0710]

I've tried two ways, it works if there is only one data table but when it comes to 2. Please help me: 

First way:

Total by Sales =

var SalesTotal =

sum('Sell out'[Tiền])

RETURN

if(isblank(SalesTotal),CALCULATE(sum('Sell out'[Tiền]),allexcept('Sell out','Sell out'[Năm out],'Sell out'[Tháng out])),SalesTotal)

Second: 

Measure = if(SELECTEDVALUE('Table'[Sales total])="Total",CALCULATE(sum('Sell out'[Tiền]),ALLEXCEPT('Sell out','Sell out'[Năm out],'Sell out'[Tháng out])),sum('Sell out'[Tiền]))

This is our data table:

[Anonymous]

Hi @MinhPham0710 ,

Please provide a sample of the data and the expected results so that we can better solve the problem for you.

Best regards,
Community Support Team_ Scott Chang

[MinhPham0710]

pls help me