Measure - different date periods

[GRT9791]

Hello,

I need help with this issue

I have a table like this in my model PBI:

In the report, I have a slicer in order to selected different activities and a calendar table with a measure like below.

The measure must be 1 when the date is within the period of the selected activity (Initial date - End date) and 0 when it is not in the period of the selected activity (like in the image). Unfortunately, my measure works when I have selected only one activity. If I select multiple activities it doesn't work correctly

Any idea how to create the measure?

It's mandatory that the table only includes two columns (date and measure).

Thanks a lot

[AilleryO · Accepted solution]

Hi,

We are lacking a lot of information to help you, but here are some tracks you might follow...

1/ Maybe you can use a variable in your measure to memorize the activity "treated" and filter only on it. Then filter the next one and so on...

2/ If your test is a calculation is it iterative, row by row ? If yes, are you using a function that iterates ?

Hope it helps, otherwise feel free to tell us more.