Forum Discussion
Evogelpohl
Helper V
7 years agoMeasure to Display Column Names Used as Filters
I have a simple model with 3 tables, Sales, Product, Calendar. Sales has Cols: ProductID, Amount, TransDate & Measure = [Total Sales] Product has Cols: ProductID, Name Calendar has Cols: Date...
- 7 years ago
I don't think there is a way Evogelpohl , even using ISFILTERED. Unless the user selects a row in the table or there are slicers on the columns then the fields are not filtered.
No row selectedWith row selected
jdbuchanan71
Super User
7 years agoI don't think there is a way Evogelpohl , even using ISFILTERED. Unless the user selects a row in the table or there are slicers on the columns then the fields are not filtered.
No row selectedWith row selected
Evogelpohl
Helper V
7 years agoRight, I meant to say if a specific value was chosen, then it would switch the ISFILTERED, HASONEVALUE functs to evaluate to true. Thanks, jdbuchanan71 .