Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
@Anonymous
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
@Anonymous
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.