Filter values at Aggregated Level

i am looking to filter values from my matrix . I have message that gives percenrage of Markup .. But i want to filter the Percentage at Customer level .. I need helpwith Dax to Filter where sub total at customer level less then certain percentage ..

Any help would be appreciated.

My Table


Customer	Product	Item
1	1	1	0.73
1	1	2	0.73
1	2	1	0.73
1	2	2	0.73
1	3	1	0.62
1	3	2	0.62
Sub Total			0.693333333
2	1	1	0.9
2	1	2	0.8
2	2	1	0.8
2	2	2	0.7
2	3	1	0.7
2	3	2	0.7
Sub Total			0.757142857



Filter Values Based on Sub Total Less 0.70

Forum Discussion

Filter values at Aggregated Level

Related content

Issue with Aggregation and Filtering

Data Aggregation issue

Filter table on dynamic, detached slicer values, then display filtered, aggregated data on a visual.

Aggregate

performing filter and aggregate function on dataset before applying TOPN