Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

couting row using filter

Hello,   I am counting the number of row in a table1 which correspond to a criteria in table2. For example,    Number of opportunities = DISTINCTCOUNT('Table2'[OpportunitySkey]) No. of Oppor...
Need Help
  • evandrocunico's avatar
    evandrocunico
    7 years ago

    Hi Anonymous try:

     

    calculate(counta('Table'[ApprovedByRiskCommittee]),filter('table1','table1'[ApprovedByRiskCommittee]<>"Y" || 'table1'[ApprovedByRiskCommittee] = blank()))

     

    regards.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous do you have two tables? Why in the filter you have Table1