Forum Discussion

DigiMarketa's avatar
DigiMarketa
Frequent Visitor
3 years ago
Solved

Filter within table

Hi,   I´m wondering how to solve my problem with filtering.   Users will within the first step filter specific products and then filter just types without/with low stock to export it.    ...
  • JorgePinho's avatar
    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"

     

  • Anonymous's avatar
    Anonymous
    3 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.