Matrix Visual Column Grand Totals are returning 100% instead of calculating x/y

[Anonymous]

Hello Experts,

@amitchandak , @Greg_Deckler 

Im currently showing Matrix Visual with Aging Bucktes in columns along with Outstandings and Percentages. In rows, im using Location Name. Each Bucket percentages are looking good but my column Grand Totals are showing 100% 

Here is my measures x/y 

1) BalanceOutstanding (x)=  

     CALCULATE(

        SWITCH( SELECTEDVALUE('Fact_AR_Invoice'[InvoiceStatusDisplay]),

            "Posted",IF(ISBLANK(SUM('Fact_AR_Invoice'[InvoicePayment])),[Invoice Values],SUM('Fact_AR_Invoice'[Balance])),

            "Paid",IF(SELECTEDVALUE( 'Fact_AR_Invoice'[CustomerPaymentDate])>[Selected Date],[Invoice Values], SUM('Fact_AR_Invoice'[Balance])),

            "New", sum('Fact_AR_Invoice'[InvoiceAmount])

    ),

    Filter('FACT_AR_Invoice',COUNTROWS(FILTER ('Aging',[Days Overdue] >= Aging[Min] && [Days Overdue] <= Aging[Max]))>0))

2) BalanceOutstanding_TotalbyLocation (Y) = Calculate(sumx('AR Measures',[BalanceOutstandingTest]),ALL('Aging'[Aging]))

3) % BalanceOutstanding_PastDue (X/Y) = [BalanceOutstandingTest]/[BalanceOutstanding_TotalbyLocation]

I tried to adjust BalanceOutstaning_TotalbyLocation measure with ALLSELECTED and VALUES but still it is showing 100% in column grandtotals. Please any quick help will be appreciated. 

Thanks in Advance 

SO

[Greg_Deckler]

@Anonymous First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8