Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

One column, two filters (using same field)

Hello community, I think this is an data model issue but maybe there is a dax function that could be helpful As you can see above, I'm trying to use twice the same field in my report as filte...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    you can try this, create 2 independent table, and put them into slicer,

    table1 = SELECTCOLUMNS('Table',"col2",'Table'[col2])
    table2 = SELECTCOLUMNS('Table',"col2",'Table'[col2])

    then create the measure, it returns the selected value,

    Measure = SELECTEDVALUE(table1[col2])&","&SELECTEDVALUE(table2[col2])

    result

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Anonymous 

you can try this, create 2 independent table, and put them into slicer,

table1 = SELECTCOLUMNS('Table',"col2",'Table'[col2])
table2 = SELECTCOLUMNS('Table',"col2",'Table'[col2])

then create the measure, it returns the selected value,

Measure = SELECTEDVALUE(table1[col2])&","&SELECTEDVALUE(table2[col2])

result

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.