Use a selected value from a slicer to check valitity of product

[johnathan]

i have 2 tables:

table 1 - ProductWeight

CODE	OutcomeWeight	IncomeWeight	percentage gap
A	10.5	10.3	-1.9%
B	22.6	21.5	-4.9%
C	33.5	30.5	-9%

table 2 - TopWeightGap

1%
2%
3%
4%
5%
6%
7%
8%
9%
10%

i made a slicer based on table 2 witch i chose the to weight gap percentage/

I want it to check which product is valid in terms of the selected percentage gap and i want to display only the valid products

[johnathan]

thank you for your help,

i must have missed somthing.

let say the selected Weightpercentage gap is 4% the result table should be -

CODE	OutcomeWeight	IncomeWeight	percentage gap	valid
A	10.5	10.3	-1.9%	1
B	22.6	21.5	-4.9%	0
C	33.5	30.5	-9%	0

i cant manage to do this with your suggested solution

[Daniel29195]

@johnathan 

if you have created the measure i have sent , 

simply add it to the table instead of adding it in the filter pane . it should return 0 or 1 base on the selection you have from the slicer. 

tell me if it works out for you .

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

[johnathan]

i created the measure as you sent it - 

Measure =

        VAR selected_gap = SELECTEDVALUE(Table2[TopWeightGap])

        var calc = CALCULATE(COUNTROWS(Table1),ABS(table1[weight_percentage_gap]) <= selected_gap)

        RETURN  IF(ISBLANK(calc),1,0)

When I add it to the table, All rows in the new column have the value 1

[Daniel29195]

@johnathan 

did you remove the filter from the filter pane ? 

[Daniel29195]

@johnathan also make sure in the code , 

VAR selected_gap = SELECTEDVALUE(Table2[TopWeightGap])

        var calc = CALCULATE(COUNTROWS(Table1),ABS(table1[weight_percentage_gap]) <= selected_gap)

        RETURN  IF(ISBLANK(calc),1,0)

that selected_gap  and weight_percentage_gap are rounded to the same decimal number . 

[johnathan]

yes i removed the filter,

and also selected_gap and weight_percentage_gap are rounded to the same decimal number (2)

[amitchandak]

@johnathan , Assuming both are percent column , create measures like

Countrows(filter(Table1, round(Table[percentage gap],0) = selectedvalues(Table2[TopWeightGap]) ))

or

Countrows(filter(Table1, round(Table[percentage gap],0) in values(Table2[TopWeightGap]) ))

[Daniel29195]

@johnathan 

so when you select let s say 1%, 

you need to show from table 1 all the products with 

Weight

percentage gap <= 1%

if that is the case please refer to the code below : 

measure = 

var selected_gap =  selectedvalue('table 2'[TopWeightGap])

var calc = 

calculate ( 

countrows(table1), 

table1[weight_percentage_gap] >= selected_gap)
)

return

if(isblank(calc),0 , 1 ) 

now select the visual , go to filter pane, add this measure to the filter pane , under filter on this visual , 

use advanced filtering -->  is --> 1 --> click apply .

tell me it works out for you . 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍