none
earliest() in dax measure

    Question

  • Hi,

    I have a measure as below which should be based on the earliest(transaction_Date).I want to include this in my measure:

    CALCULATE(COUNTROWS(DISTINCT('Inspection'[COLLECTION_ID])),FILTER('Inspection','Inspection'[FinalDate]=1&&'Inspection'[INSPECTION_RESULT]="Reject"))

    Trasaction_date is a column in the Inspection fact and is joined with Date column in the Date dimesnion.Pls help.

    Thursday, May 17, 2018 4:23 PM