Forum Discussion
Using a filter with no relationship
Make sure all your columns with numbers have a numeric data type. Also, if not already, you will need to replace the table and column names to the actual ones in your model.
Regards,
Pat
mahoneypatthanks that helped but I am still experiencing issues and its probably because I didnt explain my need well enough sorry about that .
Using your data I drop the measure in the gauge visual and it shows -8k when filtered by Deposit 1. but it should show 10k. It shows -800 when filtered by deposit 2 but it should show 7200 and it shows 8700 when filtered by deposit 3 but it should only show 800. Below is a snapshot of what I described
I want to look at the gauge on a any given day and see how much of the deposit has been spent so for example if I looked at the gauge on january 1, I would see 6,000 spent from deposit 1, 0 for deposit 2 and 0 for deposit 3. I would also like my target to adjust based on the the deposit type, so the target for deposit 1 would be 10,000, the total for deposit 2 would be 7200 and the target for depost 3 would be 9500 .Apologies for not being clear