Forum Discussion

sapirmarko's avatar
sapirmarko
Icon for Helper I rankHelper I
3 years ago

filter the report by another table

Hi evryone

I have scheme with this relatinship:

 

I want to filter all the report (filter all pages) that will show the record that 

Start date( Order_creaor_table) >= Sales_table(date)

there is a way to do it by measre? what is the best way to do it?

I don't want to create new coulmn 

 

thanks,

Sapir 

Need Help

3 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    You could create a new column in the Sales table like

    Is After Start Date = 'Sales'[Date] < RELATED( 'Order creator'[Start date])

    And then use this column as a report level filter.

      • johnt75's avatar
        johnt75
        Icon for Super User rankSuper User
        3 years ago

        I don't think you can use measures as filters at the page or report level, only at the visual level.