Forum Discussion
sum two scatter plots
Hi AlexT86 ,
Have you tried making a formula similar to the one below:
Total values =
CALCULATE ( SUM(Table[Column]), Table[Tag] = "Tag 1")
+CALCULATE ( SUM(Table[Column]), Table[Tag] = "Tag 2")
-CALCULATE ( SUM(Table[Column]), Table[Tag] = "Tag 3")
This will force the calculaiton to make the sum based on the tag.
Is this your issue or you cannot identify the specifi tag you have has negative.
Hi MFelix ,
A tag can be positive or negative depending on the analysis I want to do . For example for one calculation it is positive but for the calculation after it is negative.
I want to choose to via the two filters I set up.
I will try to attach the example.
I think the formula I set up is right, but the solution is in defining an x time axis common to the two filters.
Hi,
Sorry for the additional questions, but in the example you have attached how is the setup of the negative an positive tags? Can you guide me trough the steps that makes the selection one or another?
Thanky you and once again apologize the additional questions.