Trying to select this months data

[craigL01]

Can someone please advise where im going wrong here, im creating a measure where the first two filters are selecting data based on certtain values then i have the this month filters. When i double check my answer using a grid im getting too many records using this dax code.

AAUKNoAccessToSurveyMTD =

CALCULATE(count(PROJTABLE[PROJID]),

FILTER(ABPAWPROJNOTES,ABPAWPROJNOTES[ABPAWNOTETYPE] = "SURVEYFAILED"),

Filter(PROJTABLE,PROJTABLE[AUKProgressStatus] = "No Access to Survey"),

filter(ABPAWPROJNOTES,left(ABPAWPROJNOTES[ABPAWNOTE],9)= "No Access"),

Filter(ABPAWPROJNOTES,ABPAWPROJNOTES[ABPAWINPUTDATETIME].[Date] < today()),

filter(ABPAWPROJNOTES,ABPAWPROJNOTES[ABPAWINPUTDATETIME].[MonthNo] = month(today())),

filter(ABPAWPROJNOTES,ABPAWPROJNOTES[ABPAWINPUTDATETIME].[Year] = year(today())))+0

[v-jayw-msft · Accepted solution]

Hi @craigL01 ,

You could combine the conditions, please check the formula.

AAUKNoAccessToSurveyMTD =
CALCULATE (
    COUNT ( PROJTABLE[PROJID] ),
    FILTER ( PROJTABLE, PROJTABLE[AUKProgressStatus] = "No Access to Survey" ),
    FILTER (
        ABPAWPROJNOTES,
        ABPAWPROJNOTES[ABPAWNOTETYPE] = "SURVEYFAILED"
            && LEFT ( ABPAWPROJNOTES[ABPAWNOTE], 9 ) = "No Access"
            && ABPAWPROJNOTES[ABPAWINPUTDATETIME].[date] < TODAY ()
            && ABPAWPROJNOTES[ABPAWINPUTDATETIME].[date]
                >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 )
    )
)

Best Regards,

Jay