Help in making revenue dashboard!!!

[Aditya_K1999]

Hello People,

Please do help,

I am trying to make a revenue dashboard. Which has two data parts in it, one would payment collection and one is filter box with different fields that are multiselect. Basis the fields selected I want the data to change in the payments view.

I was successfully able to do that using the below formula:

isnotblank(
SELECT(
Dashboard[Row ID],
AND(
OR(isblank([Start Date]), [_THISROW].[Date of Payment] >= [Start Date]),
OR(isblank([End Date]), [_THISROW].[Date of Payment] <= [End Date]),
OR(
isblank([Service Name]),
IN([_THISROW].[Service Name F], SPLIT([Service Name], ","))
),
OR(
isblank([Mode of Payment]),
IN([_THISROW].[Mode of Payment], SPLIT([Mode of Payment], ","))
)
)
)
)

Now in the filter box I have added one more virtual field which basically calculates the total, for which I have used the below formula: SUM(dashboard slice[Amount Paid])

But what is happening is the amount comes & then it goes back to 0

[MiguelPilo]

Use the same filter conditions in your virtual column:

Sum( Select(YOURTABLE[Amount paid], "all filter conditions required")

[Aditya_K1999 · Accepted solution]

So I figured out the solution. It was because we were using a virtual column. Since virtual column's nature is to be dynamic it was calculating and changing back to 0. If I enter it as a normal column in database it is working fine.

Thank you!