Report from dataset with 4 levels in Live Connection data

Hi GoAnna ,

Calculated tables cannot be created in Live Connection mode unless you change to Direct Query mode.
In this case, you can try the following workaround.

Create measures for each name of the desired table.

A_010 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 5]="A_010")
A_050 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 5]="A_050")
A_110 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 5]="A_110")
A_150 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 5]="A_150")
A_210 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 5]="A_210")
A_220 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 5]="A_220")
A_236 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 5]="A_236")
A_240 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 5]="A_240")
A_250 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 5]="A_250")
A_310 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 5]="A_310")
G_s44 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 2]="G_s44")
H_Gtr = CALCULATE(SUM('Table'[Amount]), 'Table'[Level 2]="H_Gtr")
Sum_A290 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 4]="A_290")
Sum_A299 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 3]="A_299")
Sum_A974 = CALCULATE(SUM('Table'[Amount]),'Table'[Level 2]="A_974")

After adding these measures to the matrix visual. Go to Format Settings->Values->Enable Switch values to rows.

Get the following result, which hopefully meets your needs.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.