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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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 

 

2 REPLIES 2
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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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.