Forum Discussion
Using two smart filters
check out this thread
https://community.powerbi.com/t5/Desktop/or-logic-slicer/m-p/460738
solution I posted there involves creating new tables, but there is also link to SQLBI article on the matter
https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/
I will try and clarify my post:
The dashboard filters enable me to search for the individual and 'add' (the value is negative) their potential GP to the total GP, for example if they were working on a separate project and were excluded. I would also like to add one off expenses (specific filter) to the GP. As the data for these inidivuals do not overlap, I have used separate if statements using all filters and tried to sum the resulting variables. When using both filters however, the original GP is returned (Non specific person), perhaps to do with the order of the filters?
I would really appreciate it if someone could help me. Thanks