Want to use Measure to add table total from multiple sheet.

[sandee]

Hi All,

Please can anyone help me in solving the below in power Bi:

I have 4 sheets loaded in power BI, every sheet has Ageing bucket like: Current, 30+, 60+, 90+, and 120+ Bucket, total. I want the total of Current from all four sheets, and total of 30+ amount from all 4 sheets. 

I can append the query but i do not want to use this function, i want to apply some measure here.

thanks in Advance

Deepak

[MauriceMecowe]

Hi Deepak,

If you create a measure in each tab for each table in your model per bucket, you can very easily sum them in the end per bucket. 

Aging30+ = CALCULATE(
    SUM(Sheet1l[Column1]),'Sheet1'[Aging] = "30+")

Good luck,

Mauricio