Forum Discussion
Helper IIMeasure not calculating all rows on a table
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
Helper IIIt's supposed to work with a slicer that's connected to a date table consisting exclusively of Fridays.
var WE = SELECTEDVALUE('Slicer Calendar'[Week Ending])
var SP = (SELECTEDVALUE('Slicer Calendar'[Week Ending])-6)I disabled the slicer from interacting with the table and, as you can see above, it returns the Friday and Saturday dates for the week specified in the Start Date column.
I assume that these are not the source of the problem since they are correctly calling out valid dates, so the calculation has a legitimate date range to work with.
- JB
Sheet1[Start_Date] is linked to Slicer Calendar[Date] (active, filters both ways)
- tamerj1
Community Champion
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
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.