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

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi JB 

if you delete CALCULATE along with its modifiers it should work

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

It does, but once I complicate things by adding a date slicer to determine the Week Ending date, it continues to return 1 even for rows that should be 0.