Return a list of items filtered by a What-If parameter

[pegaiarsa]

Hello,

I have a dataset that has our products in column A and their corresponding gross revenue on column B. I've created a parameter called "Revenue Threshold". I use this parameter to create measures that tell me: how many products are bellow the threshold, how much revenue that represents and how many products would be left in our portfolio after the removal of those below the threshold.

Please see below a mockup of the data:

Product	Revenue
P1	10
P2	20
P3	30
P4	40
P5	50
P6	60
P7	70
P8	80
P9	90
P10	100

Measures:

Products Left = 
COUNTROWS(Table1) - CALCULATE(COUNTROWS(Table1), FILTER(Table1, Table1[Revenue] < 'Revenue Threshold'[Revenue Threshold Value]))


Revenue Lost = 
CALCULATE(SUM(Table1[Revenue]), FILTER(Table1, Table1[Revenue] < 'Revenue Threshold'[Revenue Threshold Value]))

And below you can see what is the table I want to display after selecting "50" on the Revenue Threshold slicer:

Product	Revenue
P5	50
P6	60
P7	70
P8	80
P9	90
P10	100

I'm trying to generate a table or column that shows me all the products which have revenues below the threshold. I've tried to generate a calculated table, but I'm aware that what-if parameters and calculated tables do not work togheter. Is there a way to acomplish this?

Right now there are no relationships between the Parameter and Table1. Should there be one?

I've read something about using the measure to filter a visual directly, but I couldn't make that happen.

Best Regards,

Pedro.

[johnt75 · Accepted solution]

You could create a measure like

Product is below threshold = IF( SELECTEDVALUE( 'Table'[Revenue]) < [Revenue Threshold Value], 1 )

and add that to a table visual as a visual level filter to only show when the value is 1

[pegaiarsa]

Thank you very much John. That did it!

Best Regards,

Pedro.