cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 I
Super User I

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors