Forum Discussion

Chris_23's avatar
Chris_23
Icon for Helper II rankHelper II
5 years ago
Solved

Filter Table by a measure does not work

Hello guys,   i have a little problem regarding the filter context between two tables by measure.   In Table (1) I have two columns. One with calculated margins and one with achieved margins. Are...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Chris_23 

    It is possible to build a measure by unrelated table. If and isfiltered function is a good way to try. And you need to filter your table by values in unrelated table in measure to get your result. All values need to filter one by one in filter function in your code. Or your measure will get a wrong result.

    Can you share a sample like what you are dealing with to me by your Onedrive for Business? This may make it easier for me to understand your requirement.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then 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

Chris_23 , You measure is not very clear. To filter a measure you can use the visual level filter.

 

or you need to force a context to filter a measure 

 

example

sumx(filter(values(Table[ID]), [Measure] > 100), [Measure])