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

Sheet1[Start_Date] is linked to Slicer Calendar[Date] (active, filters both ways)

 

 

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

JB 
Try to add Start Date and End Date as measures (instead of coulumns ) using SELECTEDVALUE then use the new measures in your code instead of MAX

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

    The Start and End dates are the time frames for the projects, they aren't calculated and don't follow a pattern, they're human input. 

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

      I know. But still you can add them as Measures using SELECTEDVALUE

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

        Sorry, I thought SELECTEDVALUE only worked on fields that were incorporated into a Slicer. 

         

        I tried this though and it returned all 0s unfortunately.