Forum Discussion
Count and Distinct Count showing the same labels in the values field well
- 1 year ago
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.
Yes, it is known
You could create an idea to chance the label in the ideas section
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI