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.
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |