Problem with table totals

[grojnak]

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?

Thanks in advance.

[Anonymous · Accepted solution]

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