Measure in table distinctcount/ condition

[Applicable88]

Hello,

I'm using a measure for a table where I count all the distinct orders where the duration last less than 90 minutes. Duration is displayed in seconds. 

I use something like:

Measure = Calculate ( distinctcount( 'Transporttable'transportorders), 'Transporttable' duration<5400 )

The problem I face is that tables "Total" value might be right, but at the same time I'm still seeing all tranpsort and I want those filtered out of the table and only seeing those transport which are under 5400 seconds. That means on row level and not the total value.

How to write that measure differently to reach that?

Thank you very much in advance. 

Best. 

[amitchandak · Accepted solution]

@Applicable88 , Try a measure like

Measure =
var _sum = calculate(sum('Transporttable'[duration]))
return
Sumx ( filter(values( 'Transporttable'[transportorders]), _sum<5400 ),_sum)