Get percentage of total breakdown

[newgirl]

Hello

I have a sample raw data of the receivables of the business. I'm trying to recreate the 2nd pivot in PBI and get its % breakdown  (which should be divided by the sum of 4,500). However, I'm only getting the 75%-25% breakdown after trying different measures.

How do I get the 20%-7% percentage breakdown? Please take note that I have a slicer in the page of the report that would filter the month.

Due Date	Status	Aging (Days)	Aging Status	Aging Period	Receivable Amount
5/1/2024	Legal	6	Legal	1 to 30	100
5/1/2024	Legal	6	Legal	1 to 30	200
4/1/2024	OK	36	Past Due	31 to 60	300
5/1/2024	OK	6	Past Due	1 to 30	400
5/1/2024	OK	6	Past Due	1 to 30	500
5/7/2024	OK	0	Current	Current	600
5/15/2024	Legal	-8	Legal	Current	700
5/15/2024	OK	-8	Current	Current	800
5/15/2024	OK	-8	Current	Current	900
5/15/2024	OK	-8	Current	Current	1,000

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file, whether it suits your requirement.

Amount sum: = 
SUMX (
    Data,
    CALCULATE (
        SWITCH (
            SELECTEDVALUE ( Data[Status] ),
            "Legal", BLANK (),
            SUM ( Data[Receivable Amount] )
        )
    )
)

expected result measure: = 
VAR _total =
    CALCULATE ( [Amount sum:], ALL ( Data[Aging Status], Data[Aging Period] ) )
RETURN
    SUMX (
        Data,
        CALCULATE (
            SWITCH (
                SELECTEDVALUE ( Data[Aging Period] ),
                "Current", BLANK (),
                DIVIDE ( [Amount sum:], _total )
            )
        )
    )