Forum Discussion
plmiquelon
4 years agoFrequent Visitor
Create a table based on measured values
+Hi, I would like to see if it would be possible to use values obtained from measure to create a table I want to create a table that has 2 column, one is date and second is cumulative cost. T...
- 4 years ago
You can apply any filters you need by wrapping the whole thing in a CALCULATETABLE call. You can see exactly which filters were applied to your table visual by using Performance Analyzer to get the DAX code used to generate the query for the table.
plmiquelon
4 years agoFrequent Visitor
Hi,
Thanks for your help.
My problem with this approach is that the table you see above is obtained using filter that are locally applied to specific projects. I'm not sure that the data will be maintained when creating a table
Any toughts?
Thank you
- johnt754 years agoSuper User
You can apply any filters you need by wrapping the whole thing in a CALCULATETABLE call. You can see exactly which filters were applied to your table visual by using Performance Analyzer to get the DAX code used to generate the query for the table.