Filter within table

[DigiMarketa]

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. 

Is there any possibility how to solve this within PBI?

Many thanks

[JorgePinho · Accepted solution]

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"

[DigiMarketa]

Hi,

thank you both for your solutions. Both is possible way, how to do it.

Regards, 

Marketa

Regards

[Anonymous · Accepted solution]

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.

[JorgePinho · Accepted solution]

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"