Measure to filter rows by date

[LuisGerardoSR]

Hello everyone!

I would like to create a measure to filter the number of days for 'Cama Alta' for either one of the specific dates listed on the rows. Right now it is adding the number of days for both dates. I need the measure to bring either value, not the sum of them.

Thanks!

[camargos88]

Hi @LuisGerardoSR ,

I'm not sure I got your point but you can use it with slicers, so it will filter your data. Also if you are using it on visuais, check the summarization, if it's numeric the default should be sum. You can change it.

If I don't answered you question, please give us more details about what you are doing.

[LuisGerardoSR]

I used the slicer to select the date I want, but it will not give me the correct days. It brings the sum of days for both dates, even if only one date is selected.

I am looking for a measure that will filter out the rows by date and then bring the correct number of days.

[camargos88]

Hi @LuisGerardoSR ,

Can you post a sample of your data and how you expect the results ?

[LuisGerardoSR]

The following is a matrix where it lays all the data. It is adding all the values instead of separating them by date.

I am also posting the table where it is pulling everything from.