Forum Discussion

unkCandy's avatar
unkCandy
Helper I
3 years ago
Solved

Get the Filtered values based on a bar chart

Hello Community,  I am working on a measure to get me the filtered ids based on a person and put them in a table to get the whole process of the filtered ids.    My table has three values:  Id ...
  • v-xiaotang's avatar
    3 years ago

    Hi unkCandy 

    Please try this ,

    Measure = 
    var _person=SELECTEDVALUE(Person[Person])
    return IF(MIN('Table'[Id]) in SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[Person]=_person),"ids",[Id]) ,1,0)

     

     

    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.