Forum Discussion

s45kougo's avatar
s45kougo
Icon for Helper I rankHelper I
6 years ago
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...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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

abeldiazcastano's avatar
abeldiazcastano
Frequent Visitor
1 year ago

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 🙂