Forum Discussion

donnarenia's avatar
donnarenia
Frequent Visitor
7 years ago
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 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

  • pbeye's avatar
    pbeye
    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.
      • pbeye's avatar
        pbeye
        Resolver 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.