Forum Discussion

SandeepKomminen's avatar
SandeepKomminen
Regular Visitor
9 years ago
Solved

dimensional data modelling design - Data warehouse

I am having dimension tables item (item_id,name,category) Store(store_id,location,region,city) Date(date_id,day,month,quarter) customer(customer_id,name,address,member_card) fact tables ...
General Comment
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    you don't have to add the average to you fact table. Using Power BI there are 2 two ways to show the average

    • just use the column unit_sold_cost in any visual and change the aggregation function that you want, it's also possible to use the same column more than in once in the same visual with different aggregation functions
    • just create a simple DAX statement to create a measure on top of your fact table like so avg cost = CALCULATE(AVGERAGE('nameofyourfacttable'[unit_sold_cost]))

    Regarding your question about transactions using the membership card, this is a difficult question, because even if you that a customer owns a membership card this does not necessarily mean he uses this membership card. For this reason you may implement another information in your facttable, "used membership card".

     

    Hope this answers some parts of your question

     

    Regards

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

you don't have to add the average to you fact table. Using Power BI there are 2 two ways to show the average

  • just use the column unit_sold_cost in any visual and change the aggregation function that you want, it's also possible to use the same column more than in once in the same visual with different aggregation functions
  • just create a simple DAX statement to create a measure on top of your fact table like so avg cost = CALCULATE(AVGERAGE('nameofyourfacttable'[unit_sold_cost]))

Regarding your question about transactions using the membership card, this is a difficult question, because even if you that a customer owns a membership card this does not necessarily mean he uses this membership card. For this reason you may implement another information in your facttable, "used membership card".

 

Hope this answers some parts of your question

 

Regards