Forum Discussion

venkb's avatar
venkb
Helper I
5 years ago

Filter rows based on date column

hello, I have the following measure

 

Received_Today_1 = COUNTROWS(FILTER (
ALLSELECTED(Logs),
Logs[Date] = SELECTEDVALUE('Date Table'[Date]) - 1
&& Logs[State] = "State"
&& Logs[Status] = "Success"
))
 
Received_Today_1 is a measure and all i wanting is to count based on the above mentioned filter for selected date - 1. so in the slicer if is select a date of 11/18/2020 then i want this measure for 11/17/2020. 
 
btw when i remove the -1 from the above measure it gives me the count for 11/18/2020 but when i put -1 i expect it to give me the count for 11/17 but it doesnt. what am i missing here? thanks

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    venkb , if date table is joined with the table then try like for previous day

    Received_Today_1 = COUNTROWS(FILTER (
    ALLSELECTED(Logs),
    && Logs[State] = "State"
    && Logs[Status] = "Success"
    ), previousday('Date Table'[Date]))

  • venkb's avatar
    venkb
    Helper I
    5 years ago

    thanks amitchandak, i tried the previousday function but it is still giving me the current day data. And yes the tables are linked through date.

     

    btw, my goal is to for the last 7 days from the current date. so may need outside of previousday function even if it worked (sorry - i should have mentioned that in my original note)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    What is the reason to use ALLSELECTED? This function is used to get filters from outside the visual or get all the iterated entities from a visual. I have a strong feeling you're not using it correctly. And on top of that, this is the MOST complex function in all DAX and understanding it takes a bit of learning. Could you please explain better what you're trying to do? Maybe a picture would be useful...

  • venkb's avatar
    venkb
    Helper I
    5 years ago

    here you go - i have a date slicer and i select a single date from it. based on the selection i am wanting to calculate the following measure. how many rows had a status & state of success and state respectively for

    • the selected date
    • selected date - 1
    • selected date - 2 and so on ie for the last 7 days of selected date

    hope this helps