Forum Discussion
Count and Distinct Count showing the same labels in the values field well
Hi Anonymous,
This is a known UI behavior in Power BI Desktop, especially when using implicit measures in visuals like Matrix or Table. As observed, both "Count" and "Distinct Count" appear with the same label when added to the Values field, which can lead to confusion unless they are manually renamed.
Although this is not considered a functional bug, the summarizations themselves are accurate the labeling inconsistency has been a long-standing usability concern, particularly when compared to Excel’s Pivot Table.
There is an existing Idea thread on the Power BI Ideas forum requesting clearer labeling for implicit measures, which you may consider upvoting.
https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas
Your feedback is valuable and helps highlight areas for improvement. If you wish, you can submit this formally through the Power BI Support channel to ensure it reaches the product team.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Thank you.
Community SupportHi Anonymous,
As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?
Your understanding and patience will be appreciated.
Hi v-sgandrathi,
This wasn't really a big issue for me as I know I can rename fields in the visual and I don't normally use implicit measures except for quick checks like this one. This was more of an fyi for Microsoft if it wants to make the behavior consistent with how it works in Excel where count and distinct count are labeled properly when added to pivot tables. I wanted to open a ticket with MS Support but somehow landed here. Is this a known issue/bug?
- v-sgandrathi
Hi Anonymous,
This is a known UI behavior in Power BI Desktop, especially when using implicit measures in visuals like Matrix or Table. As observed, both "Count" and "Distinct Count" appear with the same label when added to the Values field, which can lead to confusion unless they are manually renamed.
Although this is not considered a functional bug, the summarizations themselves are accurate the labeling inconsistency has been a long-standing usability concern, particularly when compared to Excel’s Pivot Table.
There is an existing Idea thread on the Power BI Ideas forum requesting clearer labeling for implicit measures, which you may consider upvoting.
https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas
Your feedback is valuable and helps highlight areas for improvement. If you wish, you can submit this formally through the Power BI Support channel to ensure it reaches the product team.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Thank you.