Calculate SUM of dax measure

[revansh]

Hi,

I have my data like:

state hours  days

NY    100      1

NY     140      2

NJ     100      1

NJ      200     2

NJ     300      3

dax:   HOURS_PER_DAY= SUM(HOURS)/ MAX(DAYS)

RESULT TABLE IN POWERBI:

STATE    HOURS_PER_DAY

NY             120

NJ              200

TOTAL       280

MY REQUIREMENT:

STATE    HOURS_PER_DAY

NY             120

NJ              200

TOTAL       320

i WANT TO SHOW total as sum(hours_per_day) .

Thanks

[TomMartens · Accepted solution]

Hey,

this measure

Measure = 
SUMX(VALUES('Table1'[State]),
	CALCULATE(SUM(Table1[Hours])
		,ALLEXCEPT('Table1',Table1[State])
	)
	/CALCULATE(MAX(Table1[Days])
		,ALLEXCEPT('Table1',Table1[State])
	)
)

creates what you are looking for

Hope this is what you're looking for

Regards