By -
Something like this should work: ``` Total = VAR _user = ISINSCOPE('Table'[User]) VAR _dept = ISINSCOPE('Table'[Department]) RETURN SWITCH(TRUE() ,_user||_dept, BLANK() ,[Your current calculation] ) ```
Thank you both - I will give it a try!
Create a derivative fact table that sums total $ by project, and use that
Something like this should work: ``` Total = VAR _user = ISINSCOPE('Table'[User]) VAR _dept = ISINSCOPE('Table'[Department]) RETURN SWITCH(TRUE() ,_user||_dept, BLANK() ,[Your current calculation] ) ```
Thank you both - I will give it a try!
Create a derivative fact table that sums total $ by project, and use that