ActualValue is a metric that sums values from the table Tasks, each Indicator has one or many Taks 1-*.
The problem is that i want that the ActualValueW gives me ActualValue for the tasks linked the each indicator (each row of table Indicator), but it is giving me diferent values from the expected values.
Can you tell what am i doing wrong? Which is the correct way to do this?
@v-shex-msft thanks for the answer, but it didn't solve the problem yet, the values are still not correct.
I noticed that the metric ActualValue in Power BI is giving me the corret value by indicator (when i filter), but when i put the metric in the calculated column AtualValueW it gives me a diferent value (greater). I get the same value (greater) when i use the formula you suggested: