how to get sum of % grand total in sliced table

[rgoo]

i have a table with some slicers, when no slicers are selected the total shows 100%

when i have slicers selected, how do i modify such that the total will be show as the sum of the selected slicers i.e. the total % should be 14 instead of 100%. 

This is my current dax: 

HC_234 = CALCULATE(SUM('Hc Ship Opex Table'[HC FY23]), REMOVEFILTERS('Hc Ship Opex Table'[Office]))

i have also tried using:

HC_234 = 
VAR testt = CALCULATE(SUM('Hc Ship Opex Table'[HC FY23]), REMOVEFILTERS('Hc Ship Opex Table'[Office]))

RETURN
IF(
    HASONEVALUE('Hc Ship Opex Table'[Office]),
    testt,
    "1"

)

 but its not retuning me what i want

[amitchandak]

@rgoo , Try like

HC_234 = CALCULATE(SUM('Hc Ship Opex Table'[HC FY23]), allselected('Hc Ship Opex Table'[Office]))

or

HC_234 = CALCULATE(SUM('Hc Ship Opex Table'[HC FY23]), allselected())

[rgoo]

i have tried the 2 dax but it's not givng what i need. So far, the closest i have been is:

HC_23 = CALCULATE(SUM('Hc Ship Opex Table'[HC FY23]), REMOVEFILTERS('Hc Ship Opex Table'[Office]))

 which gives me the % grand total compared to the total when sliced. However, i am trying to get the see if it's possible to set the total to the sum of current slicked rows which in this case will be 25% instead of 100%