Forum Discussion
Helper ICombine values from visuals into a total visual
mahoneypat Anonymous
I have found a solution: It was to put the function ALL('Date') into the measures i didnt want to be affected by the slicer. And then with Daterange() i could set the static date range.
Thanks you all for thinking with me!
Helper IHi Anonymous , thank you a lot for you effort. However, I do not fully understand what you have done or trying to do. Therefore i dont know how to explain it more deeply or better. But as you can see in the screenshot above it is not really the result that i need.
I thought your requirement was to build a new table visual show results by column 6 which was calculated by substracting column 4 from 3.
You may get column3 by sum Aan and Inkoop in Table1.
Do you want to keep the filter on column3 and column4 then substracting column 4 from 3?
I filter column3 by Date(2020/10/31), filter column4 by Date(2020/10/31 - 2021/1/18) like your screenshot.
I am confused about column5 and your column6.
And 4411(column3) - 370(column4) does not equal to 4008(column6).
I may have some misunderstand of your requirement. Please show me more details about your calculated logic. And you can show me the result you want. This may make it easier for me to understand your requirement.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- SearchKnowledge
Anonymous First of all, thank you so much for the effort.
Well my requirement is to get the result of table one and table two combined into table 3 ( you can forget about colum 5, just ignore it). So in my example the result in column 3 should be 15110 - 1377 = 13.773. The tricky part is that the values 15110 and 1377 are influenced by different date ranges. So table one and two are correct as they are, i just cant combine them into table 3. When i try to make any Measure it seems that it cant refer to any visual.