Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Blank Total

Hi, I have this measure   measure= VAR dates = MAX('Posting Date'[Date] ) Return CALCULATE( COUNTROWS( 'Job' ), Filter('Duration Entry' , 'Duration Entry'[Start DateTime Local] <= dates + 21...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Super User
5 years ago

Anonymous 

I'm wondering if it is a context problem, try adding a CALCULATE around the MAX( 'Duration Entry'[Entry Number]) )

measure =
VAR dates =
    MAX ( 'Posting Date'[Date] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Job' ),
        FILTER (
            'Duration Entry',
            'Duration Entry'[Start DateTime Local] <= dates + 21 / 24
                && 'Duration Entry'[End DateTime Local] = 'Duration Entry'[Start DateTime Local]
                && 'Duration Entry'[Entry Number] = CALCULATE ( MAX ( 'Duration Entry'[Entry Number] ) )
                && 'Duration Entry'[Parts Available Not Booked Flag] = 1
        )
    )

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi jdbuchanan71 ,

    I tried it but it is not working, it acts as that filter is not there.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      it did not, I hav created calculated column to indicated if it is a max date and then use this flag.