Forum Discussion
lazarus1907
Helper I
Helper IHandling tables in memory
Hi, I am trying to get a new column for a table counting how many times each value appears on another table. Please see diagram below: With normal tables, this is relatively easy, eg. Ex...
lazarus1907
You can acheive the expected result by creating the following table:MyTable = VAR Tab1 = { 1, 2, 3, 4, 5, 6, 7, 8, 9 } VAR Tab2 = { 4, 5, 7 } RETURN ADDCOLUMNS ( Tab1, "Found", VAR C1 = [Value] RETURN CALCULATE ( COUNTROWS ( FILTER ( Tab2, [Value] = C1 ) ) ) + 0 )________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super Userlazarus1907
You can acheive the expected result by creating the following table:
MyTable =
VAR Tab1 = { 1, 2, 3, 4, 5, 6, 7, 8, 9 }
VAR Tab2 = { 4, 5, 7 }
RETURN
ADDCOLUMNS (
Tab1,
"Found",
VAR C1 = [Value]
RETURN
CALCULATE ( COUNTROWS ( FILTER ( Tab2, [Value] = C1 ) ) ) + 0
)________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
lazarus1907Helper I
Helper IGenius! Thank you very much!!!
I'd swear I've tried something very very similar to what you wrote, but I obviously did something wrong -probably when to filter.