Getting last value by combining two filters

[Anonymous]

Hello to all

I have the following historical table:

Id   Date             issueid    Release   LastRelease
1    2017-10-12    2              1               False
2    2017-11-12    3              1               False
3    2017-12-12    3              2               True
4    2017-10-12    4              2                True
5    2017-11-12    5              2                True
6    2017-12-12    5              3               False
7    2017-11-12    6              3               False
8    2017-12-12    7              4               False

What I need is to display a table to display the issueid.
In the case above I would like to display to release 2 (Release true):

issueid
3

4

Because in fact 5 was moved to Release 3 and it should not be displayed.

I'm able to make a table but 5 keeps showing... because in fact we have a True in the list. 

Any ideias?

[Zubair_Muhammad]

Hi @Anonymous

Try this calculated table

From the Modelling Tab >>>New Table

Table =
FILTER (
    SUMMARIZE (
        Table1,
        Table1[ issueid],
        "Status", CALCULATE ( VALUES ( Table1[LastRelease] ), LASTDATE ( Table1[Date] ) )
    ),
    [Status] = TRUE
)

[Anonymous · Accepted solution]

@Zubair_Muhammad Thanks for the reply

I'm getting a duplicate dates in last date... which is correct because I can get the same date for different issueid.