Forum Discussion
Filter within table
- 3 years ago
I think you can archive the desired output with 2 slicers:
1. A slicer for Product
2. A slicer for Stock. You can use the "Between mode" or the "Less than or equal to"
- Anonymous3 years ago
Hi DigiMarketa ,
I have created a simple sample, please refer to it to see if it helps you.
Create a table includes [product] column, and without relationship between the 2 tables.
Then create a measure.
Measure = VAR _SELECTED = SELECTEDVALUE ( 'FILTER'[PRODUCT] ) VAR _MINVALUE = MINX ( FILTER ( ALL ( 'Table' ), 'Table'[PRODUCT] = SELECTEDVALUE ( 'Table'[PRODUCT] ) ), 'Table'[STOCK] ) RETURN IF ( MAX ( 'Table'[STOCK] ) = _MINVALUE && _SELECTED = SELECTEDVALUE ( 'Table'[PRODUCT] ), _MINVALUE, BLANK () )If I have misunderstood your meaning, please provide more details with your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think you can archive the desired output with 2 slicers:
1. A slicer for Product
2. A slicer for Stock. You can use the "Between mode" or the "Less than or equal to"