Filter an agregated column with a slicer

[mdlm778]

Hi everybody,

I need your help once again 🙂

I have a table DATA in which I have one amount per row.

CUSTOMER        AMOUNT            DATE

C1                           10000                    01/01/2018

C1                           18000                    11/01/2018

C2                           4000                      01/01/2018

C2                           11000                    14/01/2018

I have put an element "table" on my report in which I have 2 columns: CUSTOMER and AMOUNT. And I summarize the AMOUNT with a sum. Therefore, I see:

CUSTOMER        AMOUNT

C1                           28000

C2                           15000

I want to add a numerical slicer on my page: the user will be able to enter an amount which will be the minimum that he wants to be displayed. Therefore, if the user enters 20000, the element "table" has to show only one row:

CUSTOMER        AMOUNT

C1                           28000

So I'd like to add a dynamic filter which will be the same as if I add a filter on the element on the right pane. But I don't want the user to do it in there. Only on a slicer on the page. How can I do this ?

Thanks in advance for your help,

Kind regards

[Seward12533 · Accepted solution]

Create a diconnected slicer using the New Parameter option from the modeling menu. Then create a display measure

Display Amount = IF([Amount]>=[Min Amount], [Amount])

[mdlm778]

Thanks to both of you for your reply.

Before I post, I had tried the new parameter but didn't succeed to use it correctly. Thanks to your formula @Seward12533, I succeed, adding the measure as a column of my table element. Perfect !

Thank you so much

[Anonymous]

@mdlm778,

Unfortunately you cannot use measure in slicer at this point in time. Your best bet is you to use filter on the right pane like you mentioned.