Only last date value in grand totals

[Suresh_G_Reddy]

Hi,

Few measures value in a table should be Last date values . For example in below table , count of Backlog last date value is  56 that should come in grand total insted of sum of backlogs . Is there any soulution to display like this . Please provide a solution 

Date	Handled	Backlogs
29-Nov-17	45	33
30-Nov-17	35	34
1-Dec-17	67	67
2-Dec-17	78	56
Totals	225	56

Thanks,

Suresh

[Zubair_Muhammad · Accepted solution]

HI @Suresh_G_Reddy

Try this

CountMeasure =
VAR lastdateCount =
    CALCULATE ( COUNT ( TableName[Backlogs] ), LASTDATE ( TableName[Date] ) )
RETURN
    IF (
        NOT ( HASONEVALUE ( TableName[Date] ) ),
        lastdateCount,
        COUNT ( TableName[Backlogs] )
    )