Forum Discussion
gsamaral77
Helper I
Helper ICompare columns from two different tables
Hi folks, I hope everyone is fine (and I appologize if I commited some mistake writing in english kkk) I want to count lines comparing two columns from two differents tables, something like IF(...
Hi gsamaral77
Sure. I know your problem should be that when you add my count measure into card visual it will show blank unless you select an order in table visual.
Try to build a new measure sum as below.
SUM = SUMX(SUMMARIZE(TAB1,TAB1[ID],TAB1[Nome do recurso],TAB1[Válido até]),[Count Ordem])You can use month, date or other columns in TAB1 to build slicers to filter your measures.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super Usergsamaral77 , you have to bring the other column using one of the 4 ways in other table and compare
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
gsamaral77Helper I
Helper IAnd how I can do that?