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 |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |