Column Count

[donnarenia]

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?

[pbeye · Accepted solution]

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.

[donnarenia]

How would the rank option work?

[pbeye]

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. 

[donnarenia]

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?

[pbeye]

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

[donnarenia]

I used the client name column because it will be consistent