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
    5 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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Create two independent tables on col 2

Tab1 = distinct(Table[Col2])

 

Tab2 = distinct(Table[Col2])

 

Now create measure

countrows(filter(Table, Table[Col2] in values(Tab1[Col2]))

 

Measure on slicer 2

 

countrows(filter(Table, Table[Col2] in values(Tab2[Col2]))

 

If need you can combine in single measure too

 

 

if needed refer similar example

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg