Forum Discussion

jansenuy's avatar
jansenuy
Helper I
9 years ago
Solved

Two level filtering

Hello,   I need to create a measure that filters a columnbased on two different columns separately not subsequently. To make it more understandable, I need to filter cash flow for selling transact...
  • GilbertQ's avatar
    9 years ago

    Hi jansenuy

     

    If I understand your question correctly you could create either 2 slicers, one for each of the Columns.


    Or you could also create a measure similar to the one below.

     

    My Measure = CALCULATE([Total Sales],Table1[Column] = "Selling Transations" || Table2[Column] = "Buying Transactions")