Forum Discussion

Jaya's avatar
Jaya
Frequent Visitor
8 years ago
Solved

slicer on report does not refresh calculated table

Hi,   I have a column named "Program" in both source table and calculated table. I added graphs for both source table and calculated table on my report along with a slicer. The slicer does not filt...
Need Help
  • RobertSlattery's avatar
    RobertSlattery
    8 years ago

    Yeh, calculated tables, as in Modeling/New Table/Type stuff in dax, is a "static" table.  It will not respond to filters.

     

    The error you mentined is not relevant in terms of the solution but, it is just telling you that niether of the two columns you are trying to join on has unique (non-repeated) values.

     

    The solution, if you want your table to respond to filters, is to include the Calculate Table function in the target Measures.

Jaya's avatar
Jaya
Frequent Visitor
8 years ago

Hi BalaVenuGopal,

 

Thank you so much for looking into it. I do not see my calculated table under the edit queries screen because I created the table using DAX. Is there anyway this could be achieved using DAX.

 

Thanks again!

BalaVenuGopal's avatar
BalaVenuGopal
Icon for Resolver I rankResolver I
8 years ago

Hi Jaya,

 

Could you pls expain why did u create calculated table and give me table informaton along with your exact requirement 

 

thanks

  • Jaya's avatar
    Jaya
    Frequent Visitor
    8 years ago

    Hi BalaVenuGopal

     

    I have the source table with a student start date and end date. I need to calculate how many days the student was present each month. So I created calculated columns for each student each month in the source table. Then I wanted to do a line graph that shows totals by month. But since the months are individual columns within the table I couldn't build a line graph. So I created a calculated table that computes the totals for each month. 

     

    Calculated table has monthname, totaldays in that month, program

     

    But now am unable to filter the line graph so it filters by program.

     

    Hope I did it right! Thanks.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi Jaya,

       

      Share a sample dataet, describe the question and show the expected result.

    • RobertSlattery's avatar
      RobertSlattery
      Icon for Responsive Resident rankResponsive Resident
      8 years ago

      Yeh, calculated tables, as in Modeling/New Table/Type stuff in dax, is a "static" table.  It will not respond to filters.

       

      The error you mentined is not relevant in terms of the solution but, it is just telling you that niether of the two columns you are trying to join on has unique (non-repeated) values.

       

      The solution, if you want your table to respond to filters, is to include the Calculate Table function in the target Measures.

      • MarkEvansHW's avatar
        MarkEvansHW
        Icon for Helper II rankHelper II
        7 years ago

        An example of using the calculate table function in target measures would be great, if you happen to see this and have one available.