Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello,
I need advice on how to get a count of rows with the same text in a calculated column.
Month | Count |
Jan | 4 |
Jan | 4 |
Jan | 4 |
Jan | 4 |
Feb | 2 |
Feb | 2 |
Mar | 2 |
Mar | 2 |
Simple as that. In excel it would be something like sumif.
Thanks for the advice!
Solved! Go to Solution.
@Vilem
Add this calculated column
Count = calculate ( countrows(table), allexcept( table , table[month]))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Vilem
Add this calculated column
Count = calculate ( countrows(table), allexcept( table , table[month]))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks for your quick answer.