Forum Discussion

saranp780's avatar
saranp780
Helper III
7 years ago
Solved

How to select specific value?

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 ...
  • v-lili6-msft's avatar
    7 years ago

    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