Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Need help in calculated column - count function

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...
MargusMartsepp's avatar
MargusMartsepp
New Member
2 years ago

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])
    )
)

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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?