Forum Discussion

kasife's avatar
kasife
Icon for Helper V rankHelper V
3 years ago
Solved

From to between fact tables

Hello people, I would like some help perhaps with modeling, I can't find a solution I would like to make a comparison from one table to another. For example, - table A: ID 1, ID 2, ID 3, ID 4, ID ...
Need Help
  • kasife's avatar
    kasife
    3 years ago

    parry2k II think there was some detail missing that maybe I forgot because the value wasn't matching, so I used the following measurement and it worked. 

    COUNTROWS(FILTER(_ccvs, NOT tableA[id] IN VALUES(tableA[id])))

    Thanks so much

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

kasife add a new measure as below, you can use this as visual level filter where Count is not blank

 

Count = COUNTROWS ( EXCEPT ( VALUES ( TableA[ID] ), VALUES ( TableB[ID] ) ) )

 

kasife's avatar
kasife
Icon for Helper V rankHelper V
3 years ago

parry2k II think there was some detail missing that maybe I forgot because the value wasn't matching, so I used the following measurement and it worked. 

COUNTROWS(FILTER(_ccvs, NOT tableA[id] IN VALUES(tableA[id])))

Thanks so much