Create Dynamic Summary Table Using Results of Measures

Hi WCrayger ，

Calculated table is same as calculated column, the values can't be dynamically changed by filter. if you'd like to get the dynamic table, I'd suggest you add the measure instead of the column [Subtotal Amount ]:

Firstly, generate the below table:

Test Table = 
var medianSubtotal = [Median ISP Subtotal]
var medianSubtotalMinus5 = [Median ISP Subtotal - 5%]
var medianSubtotalPlus5 = [Median ISP Subtotal + 5%]
return

UNION(
    SUMMARIZE(
        'ISP Invoice ISP Extended Subtotal Amount Calc Table'
        ,"Median Type", "Median ISP Extended Subtotal"
    
    )
    ,SUMMARIZE(
        'ISP Invoice ISP Extended Subtotal Amount Calc Table'
        ,"Median Type", "Median ISP Extended Subtotal + 5%"
    
    )
    ,SUMMARIZE(
        'ISP Invoice ISP Extended Subtotal Amount Calc Table'
        ,"Median Type", "Median ISP Extended Subtotal - 5%"
   
    )
)

Then add the measure:

Subtotal Amount = SWITCH(MAX([Median Type]),"Median ISP Extended Subtotal",[Median ISP Subtotal],"Median ISP Extended Subtotal + 5%",[Median ISP Subtotal - 5%],"Median ISP Extended Subtotal - 5%",[Median ISP Subtotal - 5%])