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,
The Sheets 1 table is filtering SAP table and not the oposite, so if you're using any filter from SAP table it will not filter target.
To solve the problem you could activate the both side relationship but it's not a good pratice and probably you could have problems in the future.