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.
Hi All,
Please help to create DAX formual for below case.
1. I have created Matrix with 3 Level of hierarchy
2. Now I need to add column with % So i created below DAX to add this % but i am getting 100% in Matrix.
6. And so on
Please help with DAX
Thanks & Regards
Jamsher
Solved! Go to Solution.
Hi:
If you are happy with:
Share of Actual = DIVIDE(SUMX(PBI_MIS_TB, [ACTUAL]),
SUMX(ALLSELECTED(PBI_MIS_TB), [ACTUAL]))Share of Budget = DIVIDE(SUMX(PBI_MIS_BUDGET, [BUDGET]),
SUMX(ALLSELECTED(PBI_MIS_BUDGET), [BUDGET]))Hi, @Whitewater100
I tried both dax
Thanks & Regards
Jamsher
Hi, @jkhan
You can try using isinscope to get the right hierarchy level and change the values at each levels.
Please refer to this tutorial.
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Best Regards,
Community Support Team _ Eason
Great Thanks @Whitewater100 for your reply.
I will test the provided solution and will update shortly.
I also got below DAX through googling. I will try both solutions.
ACTUAL_% = DIVIDE(SUM(PBI_MIS_TB[ACTUAL]), CALCULATE(SUM(PBI_MIS_TB[ACTUAL]), ALLSELECTED()))
Thanks & Best Regards
Jamsher
Hi:
If you are happy with:
Share of Actual = DIVIDE(SUMX(PBI_MIS_TB, [ACTUAL]),
SUMX(ALLSELECTED(PBI_MIS_TB), [ACTUAL]))Share of Budget = DIVIDE(SUMX(PBI_MIS_BUDGET, [BUDGET]),
SUMX(ALLSELECTED(PBI_MIS_BUDGET), [BUDGET]))User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |