How can I create a filtered table

[Raymo3u99]

I have a table with the following data.

Path	Segment	Criteria	Value
Northbound	190F	Default	276000
Northbound	190F	Increase	132300
Northbound	210B	Default	286000
Northbound	210B	Increase	132300
Northbound	220B	Default	95000
Northbound	220B	Increase	75000
Northbound	230B	Default	95000
Northbound	230B	Increase	75000
Northbound	240B	Default	95000
Northbound	240B	Increase	75000
Northbound	250B	Default	95000
Northbound	250B	Increase	75000
Northbound	260B	Default	95000
Northbound	260B	Increase	75000
Northbound	300B	Default	95000
Northbound	300B	Increase	75000
Northbound	310B	Default	95000
Northbound	310B	Increase	75000
Southbound	190B	Default	231800
Southbound	190B	Increase	109200
Southbound	210F	Default	237350
Southbound	210F	Increase	110700
Southbound	220F	Default	235350
Southbound	220F	Increase	110100
Southbound	230F	Default	262000
Southbound	230F	Increase	110100
Southbound	240F	Default	261000
Southbound	240F	Increase	109800
Southbound	250F	Default	259000
Southbound	250F	Increase	109200
Southbound	260F	Default	258000
Southbound	260F	Increase	108900
Southbound	300F	Default	306000
Southbound	300F	Increase	123300
Southbound	310F	Default	306000
Southbound	310F	Increase	123300

I need to display the path and the minimum sum ( value) of all segments within the path. I also want to be able to create a slicer on the Criteria column.

So if both Default and Increase are selected in the criteria slicer, my output should be:

Path	Min Value
Northbound	170000
Southbound	341000

If just Default is selected in the criteria slicer my output should be:

Path	Min Value
Northbound	75000
Southbound	231800

Thanks for your help.

[mwegener]

Hi @Raymo3u99 

Try this:

Min Value = MINX(SUMMARIZE(data;data[Path];data[Segment]; "Sum of Value"; SUM(data[Value])); [Sum of Value])

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Raymo3u99]

@mwegener  Thanks for the solution. It gives me the right answer. However I am unable to get subtotals on this column if there are more than one paths in a higher group. Any thoughts as to why it won't allow subtotals?

[Raymo3u99]

Matrix

[mwegener · Accepted solution]

Hi @Raymo3u99 ,

could you give an overview over your model?

I think you only have to replace the data[path] with the pathitems.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Raymo3u99]

@mwegener 

Thank you!! Your code worked perfectly for what I needed to do.