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 ...
Diagram attached. A normal one to many relationship established. Filtering is established by a slicer connected to my lookup table (table at the top). This selects a particular broker, then the rows on the connected table below are filtered to show only rows with the selected broker(s). Essentially I want a function like ALL that returns all 'currently filtered rows' opposed to 'all' rows'.
Hi Jtep
I would think that if you clicked on the Broker that it would then Filter the data to the Broker selected and then still show the cumulative total?
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?