Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Solved! Go to 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 )
)
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 )
)
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |