DAX measure help

Question

Hi experts,&nbsp;I have below data table,CompanyYearMonthDepartmentCategoryBud/ActOverheadHoursComplany12018JulDept1Cat1Act50200Complany12018JulDept1Cat3Act70200Complany12018JulDept1Cat2Act30200Complany12018JulDept2Cat1Act40200Complany12018JulDept2Cat3Act60200Complany12018JulDept1Cat1Bud60210Complany12018JulDept1Cat3Bud40210Complany12018JulDept1Cat2Bud50210Complany12018JulDept2Cat1Bud30210Complany12018JulDept2Cat3Bud50210Complany12018AugDept1Cat1Act45190Complany12018SepDept1Cat1Act60180Complany12018SepDept1Cat1Act50180Complany12018SepDept1Cat3Act70180&nbsp;For a table formatted as given I need to have a measure column that calculates Overheads/Hours so that it is dynamic upon selection of the month.&nbsp;For example, for the month of July the calculation is as follows(50+70+30+40+60)/200 (I got the desired result by using a calculated column of Overhead / Hours)&nbsp;&nbsp;But when I select 2 or more months together I get the wrong result as the denominator used is wrong. The correct calculation I need as follows if I choose the month September and July(50+70+30+40+60) + (45+60+50+70) / 200+180&nbsp;Please help.

zubair_muhammad · Accepted Answer

dilumd
&nbsp;
Something on this pattern perhaps
&nbsp;
Measure =
SUM ( Table1[Overhead] )
    / SUMX ( VALUES ( Table1[Month] ), CALCULATE ( MIN ( Table1[Hours] ) ) )

Forum Discussion

DAX measure help

1 Reply

Related content

DAX Measure

POWER BI DAX MEASURE

Help to create DAX Measure

DAX Calculated Measure

Dax measure help

Company	Year	Month	Department	Category	Bud/Act	Overhead	Hours
Complany1	2018	Jul	Dept1	Cat1	Act	50	200
Complany1	2018	Jul	Dept1	Cat3	Act	70	200
Complany1	2018	Jul	Dept1	Cat2	Act	30	200
Complany1	2018	Jul	Dept2	Cat1	Act	40	200
Complany1	2018	Jul	Dept2	Cat3	Act	60	200
Complany1	2018	Jul	Dept1	Cat1	Bud	60	210
Complany1	2018	Jul	Dept1	Cat3	Bud	40	210
Complany1	2018	Jul	Dept1	Cat2	Bud	50	210
Complany1	2018	Jul	Dept2	Cat1	Bud	30	210
Complany1	2018	Jul	Dept2	Cat3	Bud	50	210
Complany1	2018	Aug	Dept1	Cat1	Act	45	190
Complany1	2018	Sep	Dept1	Cat1	Act	60	180
Complany1	2018	Sep	Dept1	Cat1	Act	50	180
Complany1	2018	Sep	Dept1	Cat3	Act	70	180