Forum Discussion

gsamaral77's avatar
gsamaral77
Helper 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. 

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
Helper 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!!