Forum Discussion

hector3315's avatar
hector3315
Frequent Visitor
9 years ago
Solved

Count in two related tables

Hi I'm new here and I don't know if this is the place to this issue. If not let me know it and i will change it from here.   The fact is that I have 2 related tables. In one i have an id and in the...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    hector3315,

    If you drag a Matrix visual to your canvas, with ID in Rows, and the measure totalTAreas in Values, I think it will give you the result you need.

     

    Or you can add a column as described by Baskar, though I can't see from your requirements why it must be a column.

     

    Note that columns can't be used is some situations (e.g. axis on a scatter plot), measures are generally more efficient, but measures can't be used as slicers.

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Cool,

 

I suggest two ways.

 

1. Create calculated column on Table 1

 

Column =Calculate( COUNTROWS(RELATEDTABLE('Table 2')))

 

2. Create measure .

for that u have to create relationship between these two tables . then create measure 

Measure = countA('Table 2' Table_ID)

 

 

let me  know if any help

  • hector3315's avatar
    hector3315
    Frequent Visitor
    9 years ago

    Thanks for answer me but that is not what i'm looking for. I don't want a measure. I need to know the count of taskt that each id has. And i want that as a column to print each one in each row.

     

    With your first advice i get the count of all. the same that with my first formula.

     

     

    What i didn't know is that CALCULATE exists i think that is what i need i will try it and i will say if i get something.