Forum Discussion

jeanL's avatar
jeanL
Helper I
4 years ago
Solved

create table with date filter applied

I am trying to create a new table that calculates the sum and average trade of respective item, but i couldnt get it to be able to maintain the filter on the date range slicer. 

 It still returns all despite regardless of the booked_date_month slicer.  

trade_table = ADDCOLUMNS(
        SUMMARIZE(
        summary_table, 
        summary_table[Main Service],
        "ave trade rate", [Rate],
        "total trade teus", CALCULATE(SUM(summary_table[Total TEUs]), ALLSELECTED(summary_table[booked_date_month]))
      )
)

 

Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    jeanL , a calculated table will not take any slicer filter. Add date to this table, join it with date table and use the slicer to filter data in measure

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    jeanL , a calculated table will not take any slicer filter. Add date to this table, join it with date table and use the slicer to filter data in measure

    • jeanL's avatar
      jeanL
      Helper I
      4 years ago

      Hi amitchandak 

       

      Im not sure if i understand correctly. Please do help. 

      I have added the date into this table, and create a relationship to the slicer. 

      trade_table = 
    ADDCOLUMNS(
            SUMMARIZE(
        summary_table, 
        summary_table[Main Service],
        summary_table[booked_date_month]
        ),
        "ave trade rate", [Rate],
        "total trade teus", CALCULATE(SUM(summary_table[Total TEUs]), ALLSELECTED(summary_table[booked_date_month])
      ))

       

      But it still is unaffected by the slicer date change. Is there something I am not doing right?