Forum Discussion

Jtep's avatar
Jtep
Regular Visitor
9 years ago

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 ...
Need Help
GilbertQ's avatar
GilbertQ
Super User
9 years ago

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?

Jtep's avatar
Jtep
Regular Visitor
9 years ago

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'.

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    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?

     

     

    • Jtep's avatar
      Jtep
      Regular Visitor
      9 years ago

      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.

      • GilbertQ's avatar
        GilbertQ
        Super User
        9 years ago
        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?