Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX for average cost - snowflake schema

Hi Everyone,   I'm new to Power BI and DAX, I have been working with it for approx 2 weeks and I have run in to a problem.   I have two look up tables joined as a snowflake schema.    1. The Em...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Is this problem sloved? 
    If it is sloved, could you kindly accept it as a solution to close this case?
    If not, please let me know.
     
    Best Regards
    Maggie
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

Do you import data into Power BI or sue direct query?

If you import data and have such data:

Please create a measure

Measure =
CALCULATE (
    SUM ( LCR_Lookup[Hourly Cost rates] ),
    FILTER ( ALL ( Employee_Lookup ), Employee_Lookup[Resource Status] = "Active" )
)
    / CALCULATE (
        DISTINCTCOUNT ( Employee_Lookup[enterprise id] ),
        FILTER ( ALL ( Employee_Lookup ), Employee_Lookup[Resource Status] = "Active" )
    )

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Maggie,

 

Yep, I do import the data. 

I will give your advice a shot and let you know how did it go. :) 

 

BR,

Kris