Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
msayed96
New Member

Can't get a First ,Count or distinctcount of a text column unless I create a measure?

Hi,

Previously I would be able to put a text field in a table visual and ask for a distinct count or a simple count of values.

It seeems for some reason the developpers decided that we do not need this?

Because now the only way I can get this is by creating a measure, which is not necessarily efficient when you are exploring the data.
old 

msayed96_0-1755761389457.png

Now , I can’t drag the columne in fileds or value for all visuals 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @msayed96 

There has been no change in what is called implicit measures (the automatic aggregations created when you drag fields into visuals). Everything that is placed in the Values area of a table or other visuals still supports the same functionality as always, including First, Last, Count, and DistinctCount.

If you do not see these options, it usually means one of two things:

You are dragging the field into an area that expects categories (e.g., Axis, Rows, Columns) instead of Values.

There is another issue in your specific model.

To help further, it would be best if you could share a sample file and show exactly what you are trying to achieve.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickl

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

5 REPLIES 5
v-hashadapu
Community Support
Community Support

Hi @msayed96 , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.

v-hashadapu
Community Support
Community Support

Hi @msayed96 , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.

v-hashadapu
Community Support
Community Support

Hi @msayed96 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

danextian
Super User
Super User

Hi @msayed96 

Did you, by chance, or anyone who worked on that model create a calculation group? Creating one automatically discourages implicit measures. Deleting a calculation group doesn't re-enable implicit measures. You'll have to use Tabular Editor for that.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Ritaf1983
Super User
Super User

Hi @msayed96 

There has been no change in what is called implicit measures (the automatic aggregations created when you drag fields into visuals). Everything that is placed in the Values area of a table or other visuals still supports the same functionality as always, including First, Last, Count, and DistinctCount.

If you do not see these options, it usually means one of two things:

You are dragging the field into an area that expects categories (e.g., Axis, Rows, Columns) instead of Values.

There is another issue in your specific model.

To help further, it would be best if you could share a sample file and show exactly what you are trying to achieve.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickl

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors