cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jshatila Frequent Visitor
Frequent Visitor

Level of Detail Equivalent in Power BI

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:

 

Capture.PNG

 

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

 

Capture2.PNG

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

 

But instead it looks like this in Power BI:

Capture3.PNG

 

Any help with this calc would be much appreciated!

 

2 REPLIES 2
Super User
Super User

Re: Level of Detail Equivalent in Power BI

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 Frequent Visitor
Frequent Visitor

Re: Level of Detail Equivalent in Power BI

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!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 356 members 3,691 guests
Please welcome our newest community members: