Forum Discussion
Solved
Filtering within a VALUES function based on another field
Hi all - hoping someone can help me with this (my first plea for help!) I'll give an anonymised example of what I need to do - the real version is obviously a bit more complicated! I have a tabl...
Another approach is to use CALCULATETABLE(VALUES(Table[Fruit]), Table[Colour] = "green").
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Another approach is to use CALCULATETABLE(VALUES(Table[Fruit]), Table[Colour] = "green").
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Thank you very much for this mahoneypat ! It's a neat solution, and I feel it's easy for another user to read the logic 🙂
This answer is great for me too, thanks! I am calculating Average Weekly Sales per year and I couldn't manage to filter my column yearweek (containing Y2021) from the VAR that had VALUES function 🙂
