Forum Discussion

spyder_pk's avatar
spyder_pk
Frequent Visitor
2 years ago
Solved

Count values in one table based on values from another table

Hi!   Need help with DAX. I have 2 tables. I need to show the percentage of distinct count of ItemID from Table A with multiple countries of sale from Table B.   Table A   ItemID 3 4 2 1 ...
COUNT
related
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    =DIVIDE(COUNTROWS(FILTER(ALLSELECTED(TableA[ItemID]),CALCULATE(DISTINCTCOUNT(TableB[Country]))>1)),COUNTROWS(ALLSELECTED(TableA[ItemID]))

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago

=DIVIDE(COUNTROWS(FILTER(ALLSELECTED(TableA[ItemID]),CALCULATE(DISTINCTCOUNT(TableB[Country]))>1)),COUNTROWS(ALLSELECTED(TableA[ItemID]))