Ok I may be going crazy and just missed something simple, but this is driving me crazy. I've searched and tried so many solutions at this point. I want to be able to calculate the minimum Unit Price for a group, in the randomized pic below the group would be Item_ID I can get this without an issue with calculate, min, all except Item_ID The issue is that I also have roughly 50 columns that I still want to be filterable and affect the minimum value For example, I want to add a page filter to exclude the category of cleaning. The results would then go from this:To this: With the previous calculate it continues to show the min price as 50. I can't anticipate how the table may expand over the years so even if typing 50 columns into a subsequent all selected filter was doable it wouldn't work long term. Any help would be greatly appreciated!

Hi Anonymous , Try the following measure: Minimum Values = MINX( FILTER(ALLSELECTED('Table'), 'Table'[ITEM_ID] = SELECTEDVALUE('Table'[ITEM_ID]) ), 'Table'[Unit Price]) Result in attach PBIX file.

Min for group while still being externally filterable

Forum Discussion

Related content

Page Level filter for different groups

Community User Group Experience

Fabric & Azure Data User Group Program Requirements & Benefits

Calculation Group Filters

DAX and external filters