cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bvdm1980
Helper I
Helper I

totals showing same value - table relation question

Hi.

 

I have the following tables:

dim_CostActivity

fact_CostDetails

fact_BudgetDetails

 

my cost activity is ofcourse coming back in multiple tables. Unique values. So i linked this to both fact tables on the CostActivity field

What i don't get is, that when i use a measured SUM on total budget and total costs, one of these is showing same values on all rows. 

For example:

matrix table with CostActivity and TotalBudget from Budget table, and then TotalCost from cost table gives me the correct values per activity for budget, but same totals on every row for Costs. 

matrix table with CostActivity and TotalCosts from Cost table, and then TotalBudget from budget table, gives me the correct values per activity for budget, but same totals on every row for Budget.

So somehow the relations arent working like they should? 

1 ACCEPTED SOLUTION

Hi @ImkeF 

 

thanks for your reply. I double checked the settings, and all keys are same formatting. 

what i did wrong (i typed another explanation here and by typing something popped in my mind....)

i used the activity code from 1 of the fact tables, and not the activity from the dim_CostActivity table.... 😄

View solution in original post

2 REPLIES 2
ImkeF
Super User
Super User

Hi @bvdm1980 ,
indeed, that's often the reason.
Make sure that the key-columns are of the same type (text or numbers for example).

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Hi @ImkeF 

 

thanks for your reply. I double checked the settings, and all keys are same formatting. 

what i did wrong (i typed another explanation here and by typing something popped in my mind....)

i used the activity code from 1 of the fact tables, and not the activity from the dim_CostActivity table.... 😄

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors