cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Wrong row totals

Hi all,

I'm looking for some help getting the right row totals. The situation: Employees in our company have to register their worked hours in the booking system. Details about which company they work for are available in the HRM system, for that reason I had to map them in "MASTER - Employees". Last year a lot of employees switched from Company A to Company B, for that employees Power BI calculates the wrong row total.

Below is an example of one employee who switched from Company A to Company B in March 2018.

Relationship between the tables:

And the measure I used so far:

```Test =
CALCULATE(
DIVIDE(SUM('FACT - Entries'[Tijd in minuten]);60;BLANK());
FILTER(
'FACT - Employment Records';
'FACT - Employment Records'[Start Date] <= MAX('DIM - Calendar'[Datum])
&& 'FACT - Employment Records'[End Date] >= MIN('DIM - Calendar'[Datum])
)
)```

Who can help me to solve this problem? Many thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @v-shex-msft,

Thank you for your reply. The solution was to create an extra measure:

`Measure2 = SUMX(VALUES('DIM - Calendar'[Datum]);[Test])`

2 REPLIES 2
Community Support

Hi @Anonymous ,

I think you need to add if statement to check current row contents level and write a specific calculation formula with conditions based on current category fields, it will help measure to group calculation result by current category.

Measure Totals, The Final Word

If you still confused on coding formula, please share some sample data for test.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Hi @v-shex-msft,

Thank you for your reply. The solution was to create an extra measure:

`Measure2 = SUMX(VALUES('DIM - Calendar'[Datum]);[Test])`

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.