Power BI DAX function bug???

[NMP02]

This is the DAX function created for the pipeline amount, it only shows the latest amount of a certain ticket number. But, there are certain ticket numbers that the pipeline amount doesn't show up despite it correctly entered on the database.

[Anonymous]

Hi @NMP02 ,

Are you trying to get the [Project Amount] corresponding to the maximum INDEX of each ticket?
If [Pipeline Date] is empty, take the value of [Amount], and also if '[Ticket_Number / PJ Number], [Confidence Level] ) and [Date_Awarded] are empty, then it will be empty?

Please try:

Pipeline Amount =
VAR maxIndex =
    CALCULATE (
        MAX ( 'merged_redmine_Kintone_pipeline_dataset'[Index] ),
        FILTER (
            'merged_redmine_Kintone_pipeline_dataset',
            'merged_redmine_Kintone_pipeline_dataset'[Ticket_Number]
                = EARLIER ( 'merged_redmine_Kintone_pipeline_dataset'[Ticket_Number] )
        )
    )
VAR _result =
    IF (
        (
            ISBLANK ( 'merged_redmine_Kintone_pipeline_dataset'[Ticket_Number / PJ Number] )
                || ISBLANK ( 'merged_redmine_Kintone_pipeline_dataset'[Confidence Level] )
                || ISBLANK ( 'merged_redmine_Kintone_pipeline_dataset'[Date_Awarded] )
        ),
        BLANK (),
        IF (
            'merged_redmine_Kintone_pipeline_dataset'[Index] = maxIndex,
            'merged_redmine_Kintone_pipeline_dataset'[Project Amount],
            IF (
                ISBLANK ( 'merged_redmine_Kintone_pipeline_dataset'[Pipeline Date] ),
                'merged_redmine_Kintone_pipeline_dataset'[Amount],
                BLANK ()
            )
        )
    )
RETURN
    _result

Best regards.
Community Support Team_ Caitlyn