Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
93 | |
83 | |
77 | |
70 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |