Forum Discussion
Cummulative Total with filter retained
Thanks for quick reply! With ALL removed as per your code, unwanted rows are removed (good), but the profit and loss does not aggregate, ie is not cummulative. What is returned is the same as my '[Total Net Profit and Loss]' measure, a simple measure of SUM(TradeLog_table[Profit and Loss]). The aggregation is only working on one row, with the date expression appearing to have no effect.
Hi there
Do you perhaps have a diagram of how the filtering is working. It appears as though the filtering is happening with the "Cross Filter Direction" set to both for another table. Which can always complicate things?
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.