Detail level measure not working

Comanchi 6 Reputation points
2022-05-11T13:47:20.187+00:00

Hi All,
I have a FACT and a dimension , in the SQL Server database when i do a join and run the query, it show me sales amount per each item, but in my CUBE browser, when i bring in the item and sales amount, it displays all items, but the sales amount is showing as sum of all the items. please need help.
Thanks

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,821 Reputation points
    2022-05-12T01:43:47.103+00:00

    Hi @Comanchi ,

    Thanks for posting here. Regarding your question, the reason that you will get the sum of all the items is the relationship between Fact and Dimension has not been create, please go back to your SSAS project and set the relationship for these two tables.

    create-a-relationship-between-two-tables-ssas-tabular

    If you are using SSAS multidimensional mode, please refer to below document to create relationship.

    lesson-5-defining-relationships-between-dimensions-and-measure-groups

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.