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:
Solved! Go to 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"
)
))
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"
)
))
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
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
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"
)
))
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.
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"
)
))
Thanks a lot, awesome @1minManager
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |