Set analysis for Dimension

[Milaf]

Hi everyone,

I couldn't get the metrics with a score of zero to come by team name. The metric with a score of 0 is different for each team, so I thought I prepared  the dimension that provides this control correctly. But as it is, it brings no value.

I also tried with only, it didn't work.

=aggr(({<IS_SCORED={'0'}>},[Team Name]),[Metric Name])

[BrunPierre]

Hi, have you already checked "Include zero values" under Data Handling?

Perhaps, something like this as an expression.

=Avg(IS_SCORED) + Avg({1} 0)

[Milaf]

Hello, thanks for the data handling warning. I have activated it but still no metric name is listed. How does the formula you wrote work? I need to list the metrics of the teams coming in condition 0, all fields are as I wrote.

[BrunPierre]

To clarify, does the problem revolve around the Team name not being visible when its value is zero?