Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Passing single parameter to multiple fields and filtering data

Hi im try to compar 3 fields with single input value.

up on selection on single value that need to be passed to 3 fields as below ex:

InputVal=10

field1<=10

field2>=10

field3<=10

result should impact on my existing table visual which has some 20 fields from different tables.


here im bringing data from SSAS tabular with DIRECT QUERY MODE ON

so i cant do much tweeking on desktop side,i can write a measure only.

 

_selected=SelectedValue(mytbl,mytblCol)---ex 10 i selected

 

_PassSelected=Filter(myTbl,myfield1<=_selected && myField2>=_selected && myFiled3<=_selected)--here im trying to pass the selected value dynamically. plz help in writing DAX expression

 

Need Help
  • affan's avatar
    affan
    7 years ago

    Anonymous

     

    You can use the below measure

     

    Measure = var _f1=FIRSTNONBLANK(tbl1[Field1],1)
var _f2=FIRSTNONBLANK(tbl1[Field2],1)
var _f3=FIRSTNONBLANK(tbl1[Field3],1)

var _checkf1=IF(SELECTEDVALUE(tbl2[inputField])<=_f1,1,0)
var _checkf2 = IF(SELECTEDVALUE(tbl2[inputField])<=_f2,1,0)
var _checkf3= IF(SELECTEDVALUE(tbl2[inputField])>=_f3,1,0)
return
_checkf1+_checkf2+_checkf3

    Then use this measure in the visual filter and filter the values 3

     

     

    I have got the following result.

     

     

     

     

     

     

    If this helped you, please mark this post as an accepted solution and like to give KUDOS .

     

    Regards,

    Affan

     

7 Replies

  • affan's avatar
    affan
    Solution Sage
    7 years ago

    Hi Anonymous

     

    Can you share the pbix or some samples from your data and the desired result.

     

    Regards,

    Affan

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      PBIX link

      Thanks alot affan for reply here im attaching my PBIX file and Expected Output in it.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

         

         

      • affan's avatar
        affan
        Solution Sage
        7 years ago

        Anonymous

         

        You can use the below measure

         

        Measure = var _f1=FIRSTNONBLANK(tbl1[Field1],1)
var _f2=FIRSTNONBLANK(tbl1[Field2],1)
var _f3=FIRSTNONBLANK(tbl1[Field3],1)

var _checkf1=IF(SELECTEDVALUE(tbl2[inputField])<=_f1,1,0)
var _checkf2 = IF(SELECTEDVALUE(tbl2[inputField])<=_f2,1,0)
var _checkf3= IF(SELECTEDVALUE(tbl2[inputField])>=_f3,1,0)
return
_checkf1+_checkf2+_checkf3

        Then use this measure in the visual filter and filter the values 3

         

         

        I have got the following result.

         

         

         

         

         

         

        If this helped you, please mark this post as an accepted solution and like to give KUDOS .

         

        Regards,

        Affan