Forum Discussion

naninamu's avatar
naninamu
Helper IV
1 year ago
Solved

Summing values using a Hash value

Hi everyone,   Ritaf1983 thank you  - you have previously helped me out with something similar, but I'm still a bit confused and this is slightly different!   I have 3 tables which basically look...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi naninamu ,

     

    Thanks 3CloudThomas for the quick reply. I have some other thoughts to add:

     

    (1) My test data is the same as yours.

    (2) We can create a measure. 

    Measure 2 = COUNTROWS(FILTER('Table 1',[HashCode] in VALUES('Table 2'[HashCode])))

    (3) Then the result is as follows.

     

     

    Best Regards,

    Neeko Tang

    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
1 year ago

Hi naninamu ,

 

Thanks 3CloudThomas for the quick reply. I have some other thoughts to add:

 

(1) My test data is the same as yours.

(2) We can create a measure. 

Measure 2 = COUNTROWS(FILTER('Table 1',[HashCode] in VALUES('Table 2'[HashCode])))

(3) Then the result is as follows.

 

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.