Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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...
Need Help
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 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
    4 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.