Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |