Forum Discussion
donnarenia
7 years agoFrequent 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?
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.
6 Replies
- pbeyeResolver 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.
- donnareniaFrequent Visitor
How would the rank option work?
- pbeyeResolver II
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.