Exclude Certain Value from Measure

[Anonymous]

I have a measure which works well:

_m_TotRev = calculate(sum('Table'[Revenue]),ALLEXCEPT('Table','Table'[Employee],'Activity Assignment'[start_date]))

I need to exclude certain rows from 'Table' where an unrelated field (i.e., 'Experience') = 'No Experience'

I've tried various iterations of FILTER but none work

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Kindly provide the dummy data will be more helpful. 

If you'd like to filter from an unrelated table, you'd probably generate a calculated table and then filter it. similar to the below posts:

https://community.powerbi.com/t5/Desktop/Filter-on-unrelated-table/td-p/54760 

[amitchandak]

@Anonymous , you mention as another filter outside allexpect

_m_TotRev = calculate(sum('Table'[Revenue]),ALLEXCEPT('Table','Table'[Employee],'Activity Assignment'[start_date]),'Experience'[Experience] = "No Experience")

Or

_m_TotRev = calculate(sum('Table'[Revenue]),ALLEXCEPT('Table','Table'[Employee],'Activity Assignment'[start_date]),'Experience'[Experience] <> "No Experience")

Or you can add additional filter clause if needed