cancel
Showing results for
Did you mean:
New Member

## Problem with table totals

Hi there. I am new here.

I'm writing here because I am having a common issue, according to what I could see. The totals in a table. First of all, I want to expain the data. We are counting products we sold. Our schema is like this:

We have the ID number of the sell and, as columns, the producs sold. This is working fine, but when we try to make a table in PBI we have an issue with the totals:

As you can see, the total is 3253, but that same table exported to Excel gives another result (3079). this is the correct result:

I am sure that the issue is in the measures used to calculate that total in PBI. These are:

Total sells = DISTINCTCOUNTNOBLANK( 'Table'[ID_sell] )

and the one I am using in the table:

Total products sold = IF(HASONEVALUE(Table[products]),[Total sells],SUMX('Table',[Total sells]))

The individual total of each product is OK, but not the total. Can you please help me?

1 ACCEPTED SOLUTION
Community Support

Hi @grojnak,

Did you mean to use measure formula to calculate with multiple aggregations? If that is the case, I'd like to suggest you take a look at the Greg’s blog about measure with multiple aggregations:

Measure Totals, The Final Word

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Community Support

Hi @grojnak,

Did you mean to use measure formula to calculate with multiple aggregations? If that is the case, I'd like to suggest you take a look at the Greg’s blog about measure with multiple aggregations:

Measure Totals, The Final Word

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Announcements

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

#### 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!

#### Business Application LATAM Summit 2023

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

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