Forum Discussion
Cummulative Total with filter retained
Hello, I trying to get a cumulative total working for profit and loss, very similar to that found at http://www.daxpatterns.com/cumulative-total/ My formula: = CALCULATE ( [Total Net Profit and ...
If I attach the slicer to my data table the cummulative total works, but I need filtering controlled by the lookup table for other measures.
I'm gonna have a break. Cheers for the help.
So if you create a slicer on the data table it works?
But if you create a slicer off the TradeLog_Table it does not work?
Does the TradeLog_Table only have one entry per Broker?
But if you create a slicer off the TradeLog_Table it does not work?
Does the TradeLog_Table only have one entry per Broker?