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:
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!