Forum Discussion
How can I create a dynamic summary table to include in a DAX measure?
I'm trying to create a calculated table that responds to slicer(s) selections and sums spend, grouped by FiscalYear. I want to use columns from this table as arguments to the XIRR function. I think ...
Hi Anonymous ,
The cause is as what amitchandak said.
You can try to create a measure and then create a table visual.
Total Cashflow = SUM(FACT[Spend])Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserAnonymous , once you create a table it will not respond to the slicer. Only a table inside measure formula as a variable respond to slicer changes