Forum Discussion

Shalin's avatar
Shalin
Frequent Visitor
7 years ago
Solved

Show first value by date

I have a report showing products that are on purchase order, basically: Item, PO Number, Date due, Status.    I have a page level filter on status so that it only shows Orders with the right statu...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Shalin

     

    You may create a measure and then drag it to visual level filter. Attached the sample file for your reference.

    First =
IF (
    MAX ( 'Table'[Date due] )
        = MINX (
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Item] = MAX ( 'Table'[Item] ) ),
            'Table'[Date due]
        ),
    1
)

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Shalin

 

You may create a measure and then drag it to visual level filter. Attached the sample file for your reference.

First =
IF (
    MAX ( 'Table'[Date due] )
        = MINX (
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Item] = MAX ( 'Table'[Item] ) ),
            'Table'[Date due]
        ),
    1
)

Regards,

Cherie