How to select specific value?

[saranp780]

Hi.

I have a problem with DAX. First thing first, I have a suite of example data like this.

Price	Model	PriceModel
1202	A	A1202
1003	B	B1003
1801	C	C1801
1402	D	D1402
1402	E	E1402
1491	F	F1491
1001	G	G1001

My requirement is when I select Model on Slicer, it will show only lower prices. 

Such as when I select on model E(1402). Now the models A(1202), B(1003), D(1402), E(1402) and G(1001) are shown.

Then I want to change a filter to Model A. This case the models that lower prices also display (A, B and G)

Thank you for sharing your experience. 

[v-lili6-msft · Accepted solution]

hi, @saranp780

    After my research, You can do this as below:

Step1:

add a fact model table and do not create the relationship with basic table

Table = VALUES(Table2[Model])

drag the filed Model of Table into slicer

Step2:

Add a measure as below:

Measure = var _filter=CALCULATE(MAX(Table2[Price]),FILTER(ALL(Table2),SELECTEDVALUE('Table'[Model])=Table2[Model])) return
CALCULATE(MAX(Table2[PriceModel]),Table2[Price]<=_filter)

Step3:

when you do not select any model:

If you do want to show any data 

then drag measure into the visual level filter and set is not blank

If you do want to show all data 

then add a new measure

Measure 2 = IF(ISFILTERED('Table'[Model]),[Measure],MAX(Table2[PriceModel]))

then drag measure 2 into the visual level filter and set is not blank

Result:

After select model

here is pbix, please try it.

https://www.dropbox.com/s/r7rdj3xfh5tvt34/How%20to%20select%20specific%20value.pbix?dl=0

Best Regards,

Lin