Filter BEFORE aggregating

Please share a link if I’ve missed this somewhere… can’t find the answer.  Seems like a pretty basic need/question.  I have a lot of detail data, and trying to filter BEFORE the aggregation.  For instance…

PK1  Socks   29.00

PK2  Socks   28.00

PK3  Socks   35.00

I am trying to aggregate all sock spend where the individual sock spend was under $30.  Without having to pull in all the details.  Seems like I’m either doing something wrong or perhaps the model I am using is just not set up to allow for this somehow. When I try to use a custom filter or measure, the field I’m trying to use for either isn’t available - ie, not in the list to choose from.  What in the world am I missing?

0 1 897
1 REPLY 1
Top Labels in this Space
Top Solution Authors