[ Counting Results of a metric ]

[bolabuga]

Hello Everyone, Is it possible to count the results of metric?? in my case, count the number of the results "+" or "-" or "=". METRIC = IF( [SINAL]<0; "-"; IF( [SINAL]=0; "="; "+"))

[Greg_Deckler]

Not sure about your use of the word "metric". Are you referring to a measure, a table?? If METRIC is a column, you can do this with a CALCULATE(COUNTA([METRIC]),FILTER(Table,[METRIC]="+")), something along those lines. Otherwise, you might want to create a calculated table with your measure and you could do the same basic thing.

[bolabuga]

@Greg_Deckler

Oh sorry, my bad, the doubt is "COUNTING RESULTS OF A MEASURE" (after so many posts your doubt about "metric"led to me to see that i was refering to "measure" as "metric") 

Its a MEASURE that return "+" for results >0, return "-" for results <0 and "=" for results =0.

considering i have 2 measures:

var ly units = total units - LY units

trend = if( var ly units < 0 ; "-" ; if( var ly units = 0 ; "=" ; "+" ))

I would like to count the numbers of times that "-", "+" or "=" will occur when i use the "trend measure" on a list or matrix.

[v-caliao-msft · Accepted solution]

Hi @bolabuga,

You could create a calculated column

Trend = IF(Sheet13[Unit]<0,"-",IF(Sheet13[Unit]=0,"=","+"))
And then use this column in a table visual.

Regards,

Charlie Liao

[bolabuga]

@v-caliao-msft

Thanks, that will work.