The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I have a Weekly Percent column in a matrix visual that I have calculated using the following formula:
Solved! Go to Solution.
@JayPow28 , You need to make sure hours sum up over week
Var WorkHrs = sumx(values(Table[Week]),calculate(MAX('Employee Working Hours'[Working Hours])))
or
Var WorkHrs = sumx(summarize(Table, Table[employee],Table[Week],"_1",calculate(MAX('Employee Working Hours'[Working Hours]))),[_1])
@JayPow28 , You need to make sure hours sum up over week
Var WorkHrs = sumx(values(Table[Week]),calculate(MAX('Employee Working Hours'[Working Hours])))
or
Var WorkHrs = sumx(summarize(Table, Table[employee],Table[Week],"_1",calculate(MAX('Employee Working Hours'[Working Hours]))),[_1])
Thank you Amit, that sorted it.
Regards,
Jason