Forum Discussion

gsamaral77's avatar
gsamaral77
Icon for Helper I rankHelper I
5 years ago
Solved

Compare 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(...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

gsamaral77 , A new column in Tab1

 


COUNTX(filter(TAB2, TAB2[Empregado]=TAB1[Nome do recurso], TAB2[Dt. inicio execução]=TAB1[Válido até]),TAB2[Ordem])

 

 

A new measure with a common Ordernum - https://www.seerinteractive.com/blog/join-many-many-power-bi/
calculate(COUNTX(values(order[Ordem]),calculate(count(TAB2[Ordem]))),filter(TAB2, TAB2[Empregado]=max(TAB1[Nome do recurso]), TAB2[Dt. inicio execução]=max(TAB1[Válido até])))

  • gsamaral77's avatar
    gsamaral77
    Icon for Helper I rankHelper I
    5 years ago

    PowerBI says that te function filter just accept two parameters then a I use "AND" but em both cases doesn't work 🤔

     

    Why you use the function MAX?