Forum Discussion
Solved
Handling 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 🙂
Thank you for the reply, but Power BI does not accept table1[value] when table1 is a variable and not a normal table. That's the problem I had.
lazarus1907 , That ia an array, You have create table like
union(
ROW("Value", 1),
ROW("Value", 2),
ROW("Value", 3)
)