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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
donnarenia
Frequent Visitor

Column Count

I am working with Power Bi and have a list of Project IDs...is there a way to get a count to show in the total line for this column of text?  For instance...how would I get a count of the project IDs to show in the total line at the bottom...same for workstep?  is this possible?

 

Annotation 2019-08-08 145653.png

1 ACCEPTED SOLUTION
pbeye
Resolver II
Resolver II

I don't think this can be done without adding in another column or using a card visual.

 

  • You can add in the Project ID column again and set the agreggation to count (or whatever column you are looking for.)
  • You can try to create a formula to rank/index each item, but that's a lot more complicated.

View solution in original post

6 REPLIES 6
pbeye
Resolver II
Resolver II

I don't think this can be done without adding in another column or using a card visual.

 

  • You can add in the Project ID column again and set the agreggation to count (or whatever column you are looking for.)
  • You can try to create a formula to rank/index each item, but that's a lot more complicated.

How would the rank option work?

 

Actually now that I test it out, the ranking option wouldn't make a difference. It'd be the same as a doing a count on your description. 

So I created this Column index list for my table.  and it numbers it correctly, however when it interacts with another visual, the column index keeps the original number, I made the number absolute values, so whenever the table changes it keeps the original index number and do not keep sequential numbers. ... Is there anyway to do that?

Annotation 2019-08-08 181551.png

Interesting - What formula did you use to make the columnindex? I think I might have an idea on how to make it static. 

I used the client name column because it will be consistent

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.

Top Solution Authors