How to turn measures into a table, which is still linked to the date table

[Lina_B]

I have several tables imported in query, and i have created a Date table linked to them (Calendar Auto - year ; month; quarter) .  I have created measures from my imported tables.  But now I want to create a table from these measures.  I did a simple formula TableMeasures = { ([name1] , [measure1] ) , ([name2] , [measure 2]) etc. }. Nevertheless, doing so, my measures are not linked to the date table anymore. So i can't filter my new TableMeasures by date, and i don't find a way to link it to the date table. How can I create a table with my measures, that can still be linked to the date table ? 

Thank you very much

Lina

[Mariusz · Accepted solution]

Hi @Lina_B 

Tables / Columns are static ( executed on load ) so you will not be able to filter specific value in the table by slicer or visual.

You can use Measures directly in Visuals ( only measures are affected by the filter context  )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Lina_B]

Thank you for your reply!