Forum Discussion
Solved
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...
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.
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
Resolver II
Resolver IIInteresting - 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