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.
Whitewater100's avatar
Whitewater100
Solution Sage
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.