Data not grouping (repeating totals) in a table report

[DeniseHaas]

I've created a table visualization in my report that has two columns:  Business Unit (from Employee Data table) and Hires This Month (Count of Employee numbers from Hires table).  I am expecting to see the number of hires per business unit for this month.  We had 26 hires this month, but the data is showing 26 on each line item:

I was expecting to see this:

Business Unit	Hires this Month
Concrete	9
Industrial	14
Transportation	3
Total	26

If I change the Hires this Month (employee number) to "Don't Summarize" rather than "Count", I can see that all of the correct data is there.  It shows me 9 lines for Concrete, 14 lines for Industrial, and 3 lines for Transportation...Totalling 26.

I'm pretty new to PowerBI, but this seems like it should have worked with no effort.  Not sure what I've done to cause this.  Note:  The two tables are linked by the Employee number field (which seems to be working properly based on the non-grouped example above.  Thank you in advance for your help!

[amitchandak]

@DeniseHaas , Either you measure is wrong or business unit is not joined with employee table.

Share data model and measure. used for this visual.

[DeniseHaas]

Thank you.  The fields are definitely linked (which i think is shown by the second screenshot showing the correct number of lines for each group).  What could be causing my measure to be wrong?  The data in the Hire table is just straight data that I have grouped by employee number to show the most current hire date.  Could that be causing the problem?  Thanks!

[v-kelly-msft · Accepted solution]

Hi  @DeniseHaas ,

I guess your measure is  like:

Measure = CALCULATE(COUNT([Hires this month]),ALLSELECTED()) or measure=countx(all(table),[Hires this month]),right?

Modify your measure as below:

CALCULATE(COUNT([Hires this month]),FILTER(ALL(table),[Business Unit Name]=MAX([Business Unit Name]))

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@DeniseHaas , use of all, allselected , allexcept, remove filter can change behaviour