Forum Discussion

EvdMink's avatar
EvdMink
New Member
5 years ago
Solved

Calculate incomplete week data

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. 
 
Need Help
  • PC2790's avatar
    PC2790
    5 years ago

    Oh I see,

     

    Try amending your measure as below:

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

    This should work

4 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    Oh I see,

     

    Try amending your measure as below:

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

    This should work

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    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.

  • EvdMink's avatar
    EvdMink
    New Member
    5 years ago

    hi, 

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

     

    Thanks again.