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. 

naninamu's avatar
naninamu
Helper IV
1 year ago

Hi Anonymous  - probably me but when I do that all I'm getting is the HashCode/Colour table counting the colours in that table.

What I need is illustrated below. So if I put in the Group/HashCode/Colour into one table I get this:

 

 

So my final output needs to be a count of each colour ie

Blue = 10

Green = 5

Grey = 7 etc

 

Any help appreciated!!