Forum Discussion
Min for group while still being externally filterable
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...
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.
MFelix
Super User
Super UserHi 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.
Thank you so much!!! I didn't realize that you could use selected value in that manner. I assumed it could only be assigned to literally selecting a value such as from a slicer. So close yet so far away!
- MFelix
Hi Anonymous ,
It can be used in several ways depending on the context in this case since you are showing the ID in each row of your table visualization the value can be pickedup, if you want to show agregatted values you can change the measure for something similar to this:
Minimum Values = MINX( FILTER(ALLSELECTED('Table'), 'Table'[ITEM_ID] in VALUES( 'Table'[ITEM_ID]) ), 'Table'[Unit Price])Just an example may not work properly 😄