Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Operation table dimensions

Good morning

This is a very basic question. I fully understand the star model and the fact and dimension tables.

I only have one question about how it works with numbers.

I have a star model. Let's say I have all the attributes in the dimension table and also the unit costs.

I use a matrix and use the dimension table to classify the information in the fact table. I also use the dimension table to provide attributes such as color, ...

However, if I try to use the costs from the dimension table through DAX formulas, it doesn't work well. I need to do a pre-query in query to pass all that information from the dimension table to the fact table. If I have the numerical data in the fact table then it does work.

Can someone give me an explanation why dimension tables work well with attributes but not with numbers as costs?

Thank you.

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi Syndicate_Admin -Dimension tables are great for attributes and categorical data, but for numerical data, you often need to ensure that proper aggregation, context, and relationships are set up. By using DAX measures correctly and ensuring proper data transformations and relationships, you can effectively work with numerical data in both dimension and fact tables.

     

    Edit data models in the Power BI service (preview) - Power BI | Microsoft Learn

     

    Hope it helps

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!