Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |