Forum Discussion

JB's avatar
JB
Icon for Helper II rankHelper II
4 years ago
Solved

Measure not calculating all rows on a table

Hello, I need to make a table that only shows projects that started during or before the selected week, and are due to finish during or after the selected week. I intend to use a binary 1/0 result ...
all
CALCULATE
if
Max
measure
Table
  • JB's avatar
    JB
    4 years ago

    I got it to work correctly by changing the relationship between the two tables to a One to Many (the slicer date calendar being the one).

     

    Now that I've copied the technique to the actual project I'm working on, it yields mixed results - as you can see from the below screenshot, some rows that should have 1s have 0s, even when they have the identical start/end dates as rows with 1s. Do you have any idea what's causing this?

    Thanks

     

JB's avatar
JB
Icon for Helper II rankHelper II
4 years ago

Still no success ðŸ˜ž

 

JB's avatar
JB
Icon for Helper II rankHelper II
4 years ago

I got it to work correctly by changing the relationship between the two tables to a One to Many (the slicer date calendar being the one).

 

Now that I've copied the technique to the actual project I'm working on, it yields mixed results - as you can see from the below screenshot, some rows that should have 1s have 0s, even when they have the identical start/end dates as rows with 1s. Do you have any idea what's causing this?

Thanks