Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Help with measure

Hi Gurus, I am trying to create a measure which counts the values from table A when the same value is found in table B. Table A has other values but we only count the values, which are part of table ...

3 years ago

Hi Anonymous ,

Try this measure:

Measure = COUNTROWS(FILTER('Table A',CONTAINS('Table B',[Product],'Table A'[Product])))

Solution Specialist

3 years ago

Hi Anonymous ,

Try this measure:

Measure = COUNTROWS(FILTER('Table A',CONTAINS('Table B',[Product],'Table A'[Product])))

Anonymous
Not applicable
3 years ago
Hi m_alireza This worked like a charm. However I have small enhancement to this requirement. I want to put a condition on Table A so that only those records are counted. Ex. Assuming my Table A has an additional column called ProduceType(with values Organic and Non-Organic) and I want to count records in Table A where ProduceType = 'Organic' and those products exists in Table B.
- Anonymous
  Not applicable
  3 years ago
  I managed to figure this out :
  Measure = COUNTROWS(FILTER(FILTER('Table A', 'Table A'[Produce Type] = "Organic"), CONTAINS('Table B',[Product],'Table A'[Product])))
  
  Please let me know if there is a better way than this or you find any issue with it.
  
  Thanks again!
  - m_alireza
    Solution Specialist
    3 years ago
    Hi Anonymous ,
    
    Alternatively, you can try this measure:
    Measure = CALCULATE(COUNTROWS(FILTER('Table A',CONTAINS('Table B',[Product],'Table A'[Product]))),'Table A'[ProduceType]="Organic")

Related content