Forum Discussion
Data Modeling - Line Chart
Hello, I am fairly new using Power BI and am not able to get a chart representing the data I want. So, I have different type of orders (online, in-store, etc) and each order has an order numb...
amitchandak
Super User
Super Usernoemietl , I think is is case avg of sum
Try like
Sumx(Values(Table[Task]), calculate(Sum(Table[Time Value])) )
Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980
Hello,
thank you for your reply. It does not seem to be working.
Here is my formula
Avg of task cost per order type = AVERAGEX(VALUES(MasterData[OrderType]),CALCULATE(SUM(MasterData[Hours of work])))
X ; year
X ; year
Y ; the formula
Legend ; Order type
According to my data, the numbers are not matching if I do a manual calculations.
Anything you think I am doing wrong?
Thanks