Forum Discussion
How to aggregrate data with multiple tagging
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
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
Thanks Rita - I tried it works on the aggregration level but if i use strategy as a filter. It doesn't know how to dynamically change the index (for example project abc should also be appreaing there) Is there a way we can dynamically make the index according to the strategy?
Hi Anonymous
Update the formula to :
Modified PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly