Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

FILTER for a table using values coming from different tables

Dear all,
 
I'm trying to create a filter which I can apply on a report. Basically I'm looking
to get all Service Order No's <300'000 and then another filter to get all >300'000.
Unfortunately I'm getting for the moment an error message.
All inputs are more than welcome.
 
  • Einzel Filter = FILTER('Service Order','Service Order'[Service Item No_]<300000)

Need Help

2 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    3 years ago

    The FILTER function returns a table of values; a measure needs to return a scalar value. What you can do is create the measure as you have it wrapped in COUNTROWS(). This will return a value of 1 for every row in the table created by the FILTER expression. You can then add this measure to the filter pane and set the value to equals 1 and the visual will show the rows you need.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello,

       

      Thanks a lot for the input regarding - Countrow - this works fine. I unfortunately don't understand the following part.
      As moving the Measure to the fiter pane is not working for me.

      • You can then add this measure to the filter pane and set the value to equals 1 and the visual will show the rows you need.