Forum Discussion
Alternative to countrows-filter-values calculation
I have below calculations in some fields which take time to run. I am looking for alternative for same to improve performance. measure = if( countrows( filter( values( 'emptable'[type])' ,...
Deku
Super User
Super UserThis might be better
If(
"Retired" in values( 'emptable'[type])',
Calculate(
[measure_counted] ,
'emptable'[type] = "retired"
), 0
)
If you know the [measure_counted] will not return a result if filter by retired, and there are no retired
Var result = Calculate(
[measure_counted] ,
'emptable'[type] = "retired"
)
Return
If( isblank( result ), result, 0)