Forum Discussion
Average based on column
Hi all, I have below table. My goal are to show the target but I want to target be average when I filter 1 or 2 attribute. Example 1: I filter process code 310 only and the target should be a...
Hi Anonymous,
I think I've probably misunderstood your question. You probably want to show the same table but with the target changing according to the filter you're using.
If that's the case, I present another solution on page 2 of my pbix.
Hi Anonymous,
Use this measure:
Simple AVG = AVERAGE(T_AllData[Target])
The final output:
Hi _AAndrade ,
Actually I want the target reflect at another table. Now when I filter the location or month or other attribute, the target keep maintain 94.22% (which is the average of all target and not by filtering)
Regards,
Nuha