Forum Discussion

jkhan's avatar
jkhan
Helper III
4 years ago
Solved

Division in Matrix Visual

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...
DAX
Need Help
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi:

    If you are happy with:

    TOT_ACTUAL = SUM(PBI_MIS_TB[ACTUAL])
    TOT_BUDGET = SUM(PBI_MIS_BUDGET[BUDGET])

    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]))
     
    I hope this works for you.
jkhan's avatar
jkhan
Helper III
4 years ago

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