Calculate incomplete week data

[EvdMink]

All, 

I am trying to calculate the incomplete week per person. An incomplete week is when the booked hours is less than contract hours. Therefore I created a measure. 

Incomplete weeks =  if([weektotaal uren]<[Contracturen personeel],1,0)

Use the matrix table per week by person the above is not calculating the row and column totals, like in a pivot table in Excel

Please give me some advice. 

[PC2790 · Accepted solution]

Oh I see,

Try amending your measure as below:

IncompleteWeek = COUNTROWS(FILTER('YourTable',IF('YourTable'[Booked]<'YourTable'[Contract],1,0)))

This should work

[EvdMink]

Thanks a lot. This is working!

[EvdMink]

hi, 

Thanks for the comment. However, I don't get the drop down as shown. 

Thanks again. 

[PC2790]

Hi @EvdMink ,

If your measure is returning the the correct result however it is not behaving as expected while you use it in the visual against person, right click & check the settings as below:

I hope this helps.