Forum Discussion
Exclude Certain Value from Measure
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 f...
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
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