Two different level measures in table -> how to make the lowest level look neater

[FatherTheWizard]

Hello,

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.

[parry2k]

@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])) 

[FatherTheWizard]

hi,

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.

[parry2k]

@FatherTheWizard Can you share the sample dataset so that I can test it on my end. and send the solution. Thanks!

[FatherTheWizard]

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.

[v-chuncz-msft]

@FatherTheWizard,

Just simplify your model as much as possible and illustrate with dummy data.

[parry2k]

@FatherTheWizard also you can use new dax function ISINSCOPE, here is a post with more information on it.