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. 

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

Amazing!! That's works!!

 

I have a question, do you know if it's possible that measure count the amount without filter by the order? I don't know if I explain very well 🤔

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi gsamaral77 

If you don't have same Name and Date values in two tables with different orders, you can build this measure without filtering by the order.

For Example:

TAB1 

ORDER            Nome do recurso   Válido até

17117777        KL                            2021/01/03 

17115723        KD                           2021/01/03

 

TAB2                          

Ordem            Empregado               Dt. inicio execução

17115723        KL                             2021/01/03            

If you have this situation, your measure which doesn't count by order will show wrong result. The correct result should equal = 0, but this measure will return to 1.

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

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. 

 

 

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

    Hi, thanks for keep trying help me kkk

     

    In this dashboard the ideia is not look for the orders separately, but the amount that was perfomed by the scheduled workers in the scheduled date

     

    With this measure only work in a table with column order and this measure but if I put in a Card for show the total just appear "in blank", only if I selected some order than count, but the users in this dashboard won't filter by the order, will filter by the date, workers etc

     

    Do you know if is that possible? I new in DAX, don't know much about it rs

    • Anonymous's avatar
      Anonymous
      Not applicable
      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. 

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

        That worked!! Thank you very much, I was trying to do that at least 3 weeks kkk You helped me a lot!!