Forum Discussion

noemietl's avatar
noemietl
New Member
2 years ago

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...
Need Help
Tutorial Requests
  • noemietl's avatar
    noemietl
    New Member
    2 years ago

    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
    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