Filtering distinct Ids in one row, to sum values in other row

[Jordan11257]

Hi I have a table with different projects, projectmanagers, projectmembers and some other data. Because their are always multiple members assigned to a project I have everey project multiple times in that column. So if I want to calculate the average delay of project for example the result is not the atual average because some projects are doubled. What I would like to do therefore is a measure where I can sum the value of oe column while also filtering the Project column for distinct IDs: Like Filter column Project ID for distinct ID -> Sum Project delay. Can anybody help me with the formula, I didnt really find anything resambling my problem: Thank you a lot!

[Jordan11257 · Accepted solution]

I solved it by SUMX Function Distinct ID and then calculate the SUM, but thx for your help!

[v-yingjl]

Hi @Jordan11257 ,

Thanks for your sharing and glad to hear the issue is solved. You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.

Best Regards,
Community Support Team _ Yingjie Li

[v-yingjl]

Hi @Jordan11257 ,

Based on your description, not certain what is your expected output. Could you please consider sharing a sample file without any sesentive information for further discussion?

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @Jordan11257 

Please supply your data so I can work with it.

Thanks

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.