Hello everyone,
I have the following problem:
I created a Matrix with the following columns/measures:
Entity, [Beginning Balance], [Ending balance] and [Variation].
The "Variation" are basically the [Transactions] that ocurred between my Beginning Balance and Ending Balance. Also, I inserted a Date slicer to visualize the different balances in different ranges of time.
I added a formatting condition: [Variation] > 250k will be highlighted.
I created another page that only shows the values where the conditional format is true. This step was easy, I just copied the visual and pasted into the new page and I applied a filter on the visual where [Var]>250k.
The problem that I'm facing is that in order to anaylize the [Var]>250k I need to see the [Transactions] that contribute to a variation that exceed 250k in a range of time. These transactions (individually) could be not in the range of values and they are not showing.
Is there a way in which I can show a GROUP of transactions in a range of dates where the variance was >250k?
Ideally, my new matrix would be: Entity, Description, Transaction Amount where the SUM of transactions in a range of dates is >250k. The only way that I found was create a simple visual table with these columns and use the matrix with the filter [var]>250k and select the entities/accounts to show which transactions impacted in the range of time.
I also tryed this mesure:
Transactions =
VAR TotalTransactions = SUM('Cash Activity'[Transaction])
RETURN
IF(
OR(
TotalTransactions > 250000,
TotalTransactions < -250000
),
'Cash Activity'[Transactions],
BLANK()
)
But this measure does not show the SUM of transactions outside the TotalTransactions range.
Appreciate any help that can be provided
