Discrepancy in Total Row using SUM

[jcarlos]

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...

[Greg_Deckler]

@jcarlos This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[jcarlos]

@Greg_Deckler Many thanks for your quick reply.

Now, I understand the difference at Measure Totals.

However, if you look again the table, there are discrepancies even at row level.

Regards,

[Greg_Deckler]

@jcarlos Without knowing your data, I have no idea what you are expecting to see at the row level. What should the numbers be?

[jcarlos]

@Greg_Deckler The second column (Plan_NLU_by_Category) should have the same figures as the first column. In the 5th column, all the figures should be 100%.

Knowing about the measure issues...the Totals are ok in every column. 

[v-easonf-msft]

Hi, @jcarlos 

I still don’t understand why Plan_NLU_by_Category should have the same figures as Plan_NLU? 

I have checked that the calculated values of Plan_NLU and Plan_NLU_by_Category come from two different tables. 

If just compare the result in the total row, I did not find any errors in your file.

Best Regards,
Community Support Team _ Eason

[jcarlos · Accepted solution]

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,