Forum Discussion

jcarlos's avatar
jcarlos
Helper I
4 years ago
Solved

Discrepancy in Total Row using SUM

Hi there,

 

First a little bit of context:

 

I've downloaded from Primavera P6 (Excel) a file with a time series distribution of a bunch of activities.

Additionally, I've created several tables to allow me to break down the data. One of these tables has the Activity info, including their overall budget.

I want to show the %Plan based on: 

1) The overall budget of the project: Planned/Overall Budget. Using as a denominator a measure to SUM the budget units, ignoring the filters

Plan_NLU_TOTAL = CALCULATE(SUM(Activity_ID1[Budgeted_NLU]),REMOVEFILTERS())
 
2)%Plan based on Categories: Using as a denominator a simple measure
Plan_NLU_by_Category = SUM('Activity_ID1'[Budgeted_NLU])
 
When I show the Budget by one of the Categories...everything looks good:
 

However, when I apply one filter and add Months from the Calendar Project Table:

 

The values don't match.

 

I don't know why/where these discrepancies come from.

 

Any idea?

 

Attached my pbix file.

 

JCZP_pbix 

 

 

Thanks in advance...

 

 

Need Help
  • jcarlos's avatar
    jcarlos
    4 years ago

    Hi!,

     

    Many thanks for taking the time to review my model.

     

    Data comes from different tables because one had the project baseline information and another was a kind of activities master.

     

    Anyway, I will close this thread. I've modified a little bit my model: I've created an additional table with the original budget for every activity. Now, all the measures work fine.

     

    Again, thank you a lot for your time.

     

    Regards,

     

6 Replies