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.
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?
