Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Suresh_G_Reddy
Regular Visitor

Only last date value in grand totals

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 

 

DateHandledBacklogs
29-Nov-174533
30-Nov-173534
1-Dec-176767
2-Dec-177856
Totals22556

 

 

Thanks,

Suresh

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

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] )
    )

Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

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] )
    )

Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.