Forum Discussion

Helper III

1 year ago

Solved

Calculate based on other columns

Hello, I have this similar dataset: Id Task Progress Id Main task 1 Main task 1 ? 2 Sub task 1 55 1 3 Sub task 2 20 1 4 Main tas...

Need Help

Tips and Tricks

vojtechsima

1 year ago

Hello, Peavey
Try something like this:

Average progress = 
var currentId = SELECTEDVALUE('Table'[Id])
var averageSubtasks = AVERAGEX(FILTER(ALL('Table'), 'Table'[     Id Main task] = currentId), 'Table'[     Progress])

return averageSubtasks

Peavey

Helper III

1 year ago

Thanks for all the help, I found vojtechsima solution to fit my needs very well!

This community is so impressive, so much knowledge and helpful people here, many thanks again!

-A-

vojtechsima
Super User
1 year ago
Peavey Happy to help, kudos appreciated. Thank you too