Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Everyone. So my requirement is to create a column - "Serial Number Count" in the matrix table. I have used the below dax in order to group by all the columns in the table but, the issue is, for few rows the count is coming correctly and for few rows the count is coming too high, which is wrong. For few of the wrong counts, the data is populated as the whole total from the table. I am attaching the screenshots below. Please refer them.
I am using 2 different Dax's : (
1)
Screenshot with correct count:
Screenshot with wrong count:
The right count of this product is 221 but it is showing as 5232 which is the total of that product in the source.
How do I fix this?
Any help would be much appreciated. Thank you so much in advance!
The DAX functions you're using, specifically SUMMARIZE, are generally used to create new tables rather than calculated columns. This could be the reason why you're getting incorrect counts.
Use a Measure Instead of a Calculated Column
Serial Count Measure =
DISTINCTCOUNT(agg_invent_serialid_chatbot[INVENT_SERIALID])
If you need a calculated column you could use:
Serial Count Column =
COUNTROWS(
FILTER(
ALL(agg_invent_serialid_chatbot),
agg_invent_serialid_chatbot[PRODUCT_NAME] = EARLIER(agg_invent_serialid_chatbot[PRODUCT_NAME]) &&
agg_invent_serialid_chatbot[INVENT_LOCATION_NAME] = EARLIER(agg_invent_serialid_chatbot[INVENT_LOCATION_NAME]) &&
agg_invent_serialid_chatbot[Config ID] = EARLIER(agg_invent_serialid_chatbot[Config ID]) &&
agg_invent_serialid_chatbot[ITEM_NUMBER] = EARLIER(agg_invent_serialid_chatbot[ITEM_NUMBER])
)
)
Hi @MargusMartsepp I have tried creating the calculated column using the DAX you've mentioned. I am getting wrong count as below:
The first column is the calculated column which I have created using the dax you have mentioned.
Am i doing any thing wrong here?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |