a simple sum function giving blank result

[UmairKamal]

My Report contains the following headers

Date / Time
Officer
Street Name
Record Type
Event Date
Device ID
Summary Type
Time Spent (hh:mm:ss)
Map View
Time
Key
Number
Week
Visits
Total Seconds

The summary Type contains break Start, Break end, Shift start, Shift end, Enter Street and Exit Street depending upon the type of tour by the Patrolling Offier. 

The Time Spent (hh:mm:ss) contains the difference between two events and shows the value against second event e.g. Break End, Exit Street etc. and is in the format hh:mm:ss

I converted this in total seconds in Power BI and the result is in the Total Seconds Column.

I have used this to create other measures, however, when I create a measure to calculate the total break time in seconds using the DAX below, I get a blank result

Total Break Time (seconds) =

CALCULATE(SUM('Report'[Total Time (seconds)]), 'Report'[Summary Type] = "Break end")

Any advice on this will be appreciated. thanks.

[bcdobbs]

Few things to check...

Is your seconds column showing as a number column (integer, decimal or currency).

Is "Break end" exactly the value... check for spaces at the end. (You can use Trim in transform data to sort).

[_AAndrade]

Hi @UmairKamal,

Could you share a simple pbix with some date so I can take a look?

[UmairKamal]

unfortunately I am unable to upload any data from my work laptop. but thanks for your response, i worked it out myself. there was an issue with the filters which was causing the blank results.