Pivot Table Filter Values

[uk747]

My Data Source is

Name	Occupation	Age
Tom	Builder	31​
Fred	Builder	18​
Amy	Mechanic	35​
Jo	Engineer	25​
Mary	Engineer	22​
Gary	Builder	31​
Mike	Engineer	21​

When i insert a Pivot Table with Occupation and Age in Rows and Occupation in Values as Count (Layout Table Format) I have below:

I want to then do a filter for Age >=30 but when I click on the Dropdown for Age ,Value Filters, Greater than or Equal To their isn't an option for Age, just Count of Occupation
I know I could Select Age Filter and Just check Values over 30 e.g. 31 and 35 but if more Data is loaded and refreshed the new values e.g. 37 41 etc are unchecked as it retains the initial filter I selected(31 and 35)

Occupation	Age	Count of Occupation
Builder	31​	2​
Engineer	22​	1​
	25​	1​
Mechanic	35​	1​
Grand Total		5​

 

[ExcelToDAX]

Age must not be a number column, instead it is a text value. Not sure how your table is setup, but I would try to convert the Age column to a value

 

[uk747]

Table is Set up as per Data Source in opening post and everything formatted as General in source Table

Pivot is by adding Occupation and age to Rows and Occupation to Values as Count

One weird thing is I did add some new rows to my table and when refreshed the age went to right hand side. Added these 4

keith	engineer	25
mabel	engineer	40
glen	engineer	40
harry	engineer	23

Occupation	Age	Count of Name
Builder	39​	1​
	18	1​
	31	2​
Engineer	23​	1​
	25​	1​
	40​	2​
	21	1​
	22	1​
	25	1​
Mechanic	35	1​

 

[uk747]

Also is possible to Filter twice on the same Field e.g. Filter by Builder Greater then 20 and Filter by Engineer Greater than 30 Maybe a grouping option