The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.