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

I tried use LOOKUPVALUES, but how 1 order can have multiples tasks that brings problems. And I just can create a relationship many to many, is that a problem?