Find the amount of data from another table

[Uk]

Hi there I need your help about the expression of this situation.

I have a table named as follows:

1. TableA, consists of these columns ID, Name, Count Good, Count Bad, and Count Worse

2. TableB, Consists of these columns DATE, STRUCTURE, STEP, Good, Bad, and Worse

I want to find the find the amount of data from another table.

Let say when Column Good added by AA, Column Count Good will count the amount of AA, etc.

Can we use Count(Fil

illustration: 

[1minManager · Accepted solution]

So at the moment those formulas would ignore [Step] and just count the entire table.  To count where [Step]="Step 1" then change to:

COUNT(Select(Table2[KeyColumn],AND(
   IN([_ThisRow].[Name],[Good]),
   [Step]="Step 1"
   )
))

[1minManager]

If Table2[Good] is an ENUMLIST (which it should be) then:

COUNT(Select(Table2[KeyColumn],IN([_ThisRow].[Name],[Good])))

Otherwise try using CONTAINS():

COUNT(Select(Table2[KeyColumn],CONTAINS([Good],[_ThisRow].[Name])))

 Simon, 1minManager.com

[Uk]

Hello, thanks @1minManager  How if it is also based on the Step (TableB) ?

When AA is at the Step 1, it will count 2, but When AA is at step 2, I will be 0 ?

Thanks a lot dude

[1minManager · Accepted solution]

So at the moment those formulas would ignore [Step] and just count the entire table.  To count where [Step]="Step 1" then change to:

COUNT(Select(Table2[KeyColumn],AND(
   IN([_ThisRow].[Name],[Good]),
   [Step]="Step 1"
   )
))

[Uk]

Nice It works, Fantastic, Thank you 😁

One more Please @1minManager 

How If there are more than one table? 

Should it use IFS?  

Ifs(
COUNT(Select(Table2[KeyColumn],AND(
   IN([_ThisRow].[Name],[Good]),
   [Step]="Step 1",
COUNT(Select(TableC[KeyColumn],AND(
IN([_ThisRow].[Name],[Good]),
[Step]="Step 1",
   )
))

this is the illustration.

[1minManager · Accepted solution]

No, something like this if you're wanting the sum of both tables:

COUNT(Select(Table2[KeyColumn],AND(
   IN([_ThisRow].[Name],[Good]),
   [Step]="Step 1"
   )
))
+
COUNT(Select(Table3[KeyColumn],AND(
IN([_ThisRow].[Name],[Good]),
[Step]="Step 1"
)
))

[Uk]

Thanks a lot, awesome @1minManager