Forum Discussion
How to aggregrate data with multiple tagging
- 2 years ago
Hi Anonymous
You can add an index column by project level using the linked method:
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-queryand after you'll get the table like :
you can create a simple measure for summarizing only the first row of every project:
Cf_ = CALCULATE(sum('Table'[Cf]),'Table'[Index]=1)Result :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 2 years ago
Hi Anonymous
1. You need to merge the tables to get 1.
Please check this guide :
https://www.youtube.com/watch?v=m4feUpoDpVI2. According to the index it is not a part of UI.
you have to create it. I gave the link to the guide in my first response :
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-queryIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Works like a charm. Thanks RITA!
- Ritaf19832 years agoSuper User
Happy to help 🙂