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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors