Filtering data from Google Analytics depending on results from two tables

[lulumedina]

Hello! 

I want to filter data depending on whether is having results or not on other different two tables.

for example, I have three columns: Goal Completions, Goal 1 Completions, Goal 7 Completions

I want to show only the sum of Goal 1 and Goal 7 Completions on the total of Goal Completions, like I don't want to show the numbers from Goal Completions if Goal 1 and Goal 7 have 0 (please see image attached) I just want to show the total if Goal 1 and Goal 7 have numbers.

Is there a way to achieve this?

Thank you in advance!

[Fowmy · Accepted solution]

@lulumedina 

Use the following measure to calculate the total:

Total = 
SUMX(
    table,
    IF( table[goal 1 completions]> 0 && table[goal 7 completions]> 0 ,  table[goal completions] )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[lulumedina]

Hi Fowmy and v-lionel-msft, 

Thank you for the help, I did the sum of the two tables and I think that worked well, 

I'm going to try your alternatives.

Thank you very much for your help.

[v-lionel-msft · Accepted solution]

Hi @lulumedina ,

Try this.

Measure = 
VAR __sum = MAX([goal 1 completions]) + MAX(goal 7 completions)
RETURN
IF(
   __sum > 0,
   __sum, blank()
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy · Accepted solution]

@lulumedina 

Use the following measure to calculate the total:

Total = 
SUMX(
    table,
    IF( table[goal 1 completions]> 0 && table[goal 7 completions]> 0 ,  table[goal completions] )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn