Level of Detail Equivalent in Power BI

[jshatila]

Hi All,

I have a calculation in Tableau I would like to replicate in Power BI. The calculation is fixing the level of detail as follows:

Tableau:

{FIXED [Month], [Restaurant Number], [Employee Role Name],
[Employee Role Type], [Employee Tenure Band]:
MAX([Store Headcount])}

And I am trying to replicate in Power BI as follows:

_StoreHeadcountFixed = 
CALCULATE(
    SUM(Sheet1[Store Headcount])
    ,ALLEXCEPT(Sheet1,Sheet1[Month])
    ,All(Sheet1[RestaurantNumber])
    ,allexcept(Sheet1, Sheet1[Employee Role Name])
    ,ALLexcept(Sheet1,Sheet1[Employee Tenure Band])
)

This is what the data looks like blown out:

When looking at the monthly level of granularity I expect my data to look like this (Tableau):

So it is basically summing up Store Head Count for each month.

But instead it looks like this in Power BI:

Any help with this calc would be much appreciated!

[Anonymous]

When you see a repeating figure like that it's more than likely a relationship issue. Can you upload the data model or at least a screenshot?

[jshatila]

This is actually just a flat excel file. The layout of the data resembles the first image in the post (besides the measure in the last column obviously). Thanks!