This is probably easy one.
I have Actuals and Budget measures in table in different columns. Rows are Team and below that employees of the team(s). Budget data is on Team level and Actuals are Team+Employee level so one level lower/detailed compared to budgets. The problem is that when I drill down to employee level on the table the budget column shows the team level total for each employee. I know this cannot be fixed because the different granularity but what I would like to do is to show empty on employee level for Budget column.
Is that possible by modifying the measure etc? That would make users feel less confusing.
@FatherTheWizard you can check if you are employee level then don't show budget, update your measure something like this.
Budget = IF( NOT(HASONEFILTER( Table[Employee])), SUM(Table1[Budget]))
Unfortunately that formula did not work for me. Actually after applying that it showed all the possible employees under each team in the result table so it worked out a bit worse actually. I do not know what should I change.
Thanks for the tip on ISINSCOPE. However, I am not quite sure if that could be utilized here.
Unfortunately that is not possible. I understand it is quite difficult to explain and understand complex data model without getting access to it. Probably I need to trial and error.
Just simplify your model as much as possible and illustrate with dummy data.