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. 

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Chris_23 

Your measure seems to be complex, please share a sample by your Onedrive for Business.

This will make it easier for me to understand your requirement.

Did you build a one to many relationship?(Table1 one, Table2 many)  You can try to change the cross filter direction from Single to Both. Or you can build a filter measure and add this measure into the visual filter field.

Filter measure =
IF(your condition, 1,0)

Then add this measure into visual filter and set the measure to show items when value =1.

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. 

 

 

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

Hi Anonymous 

 

so do I have to build a relationship between the tables to get them into filter context. Is it not possible to filter from a Table with a measure which is not direct linked to the model?

 

 

Kind regards

Chris

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.