Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Total table

Hello!   I need to take the Total Line from numerous tables and put them in one table!     Every green box is a table's total which derives from different filters in each table. The task is...
Need Help
Show and Tell
Tips and Tricks
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Anonymous ,

Sorry I'm not very clear about where are the values in green box from. Could you please explain more about the expression "Every green box is a table's total which derives from different filters in each table."

 

Best Regards,
Community Support Team _ kalyj

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Every green box is a table visual. For example the A1A2 is the total counts of this table. I have renamed the "Total" with A1A2, A3, A1 etc. For instance, A1A2 - 126 means that the total counts (sum of the rows) on this table visual is 126. Each table (i.e. each green box) has different filters on it that is why I have different totals. Basically I need to extract the total of each table and then sum it. Please feel free to ask if it isn't still clear.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Another approach that would lead to a possible solution is this:

       

      I want to create a measure that count rows from a table

      Measure1 = COUNTROWS(Table1)

       

      and then filter it by three measures:

      Measure2 < 0.04

      Measure3 < 0.04

      Measure4 >= 0.15

       

      Any clues?