Forum Discussion

lulumedina's avatar
lulumedina
Frequent Visitor
5 years ago
Solved

Filtering data from Google Analytics depending on results from two tables

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!

Need Help
Tips and Tricks
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    5 years ago

    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

     

  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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.

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    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

     

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.

  • lulumedina's avatar
    lulumedina
    Frequent Visitor
    5 years ago

    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.