Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to 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
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |