Forum Discussion

Anonymous's avatar
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 ...
Need Help
  • m_alireza's avatar
    m_alireza
    3 years ago

    Hi Anonymous ,

    Try this measure: 

    Measure = COUNTROWS(FILTER('Table A',CONTAINS('Table B',[Product],'Table A'[Product])))
Anonymous's avatar
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's avatar
m_alireza
Icon for Solution Specialist rankSolution 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")