Forum Discussion
tonijj
Helper IV
Helper IVPower Query - Group by combined with FILTER
Hi all, Been searching for a solution for my issue for some time, but its time to ask for some expertise 🙂 WHAT I want to achieve - I want to take a dataset and sort out by whats "in scope" ...
amitchandak
Super User
Super Usertonijj , You can use a measure in visual, no need to group data in the Power query
calculate(Sum(Table[Item value]), filter(Table, Table[In Scope] = "X"))