How to add a sum measure into another measure?

[annie_liu]

I am trying to create a measure called "VUL % overall hrs" that will give me the percentage of the sum row for Total VUL Hrs.

Currently, my NonHolidayLeave column is created by measure where it's the SUMtotal of Sum (('datatable'[colum1])-SUM('datatable'[column2])) 

I want to see the percentage of the Sum Total Vul /( Total of the Sum Measure Calculated Non Holiday Leave + Row SUM Expense Hrs.)

 Row 1 = 4 /(16+37) =7.55%

 Row 2 = 6 / (8+23) =19.35%

[Anonymous · Accepted solution]

Hi @annie_liu ,

1. because you do not provide the sample data, i create a table to test, below is my test table

Table:

2. create a measure with below dax formula

VUL % overall hrs =
VAR _a =
    SELECTEDVALUE ( 'Table'[Row Sum Expense Hrs] )
VAR _b =
    SELECTEDVALUE ( 'Table'[Sum Measure Calculated Non Holiday Leave] )
VAR _c =
    SELECTEDVALUE ( 'Table'[Row Sum Total Vul Hrs] )
RETURN
    DIVIDE ( _c, _a + _b )

3. add a table visual

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Wilson_]

Hi Annie,

I found it hard to follow along and understand how the data and visual is set up. Can you also share the relevant columns and rows from the raw data that make up your screenshot?