Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create a calculated table filtering by a measure

Hi,   How can i create a calculated table filtering this new table by a measure that i created?    
  • Anonymous's avatar
    Anonymous
    3 years ago

    I Solved using dax, ty everyone!

v-xiaosun-msft's avatar
v-xiaosun-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

Calculated Tables are created at refresh time, while Measures are calculated at query time. After you create a calculated table, please establish a relationship between your fact tables and your calculated table, and then you can use a slicer to filter the new table.

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I Solved using dax, ty everyone!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    The reaason why i want this is because i want to be able to calculate the function of a trend line that i get when i compare two measures that i have in my table. Maybe to do that is not necesary to all calculations again in a new calculated table?

     

    Thanks everyone.