Forum Discussion
change change data label text in chart
You normally get this generic Count Of... - when you drag a field (that is not data type number) to the Values area of your chart
What you need to do is write a Measure that duplicates this behavior.
You can then name it whatever you wish and use it in the Values area of your bar chart instead
Regarding which COUNT function to use - you'll have to tell us more what you want to count and how
In general COUNTROWS count all rows, COUNTA does not count blanks so...
COUNTROWS (Table) = COUNTA( Table[Column] ) + COUNTBLANK ( Table[Column] )
And if you need a distinct count you can use DISTINCTCOUNT ( Table[Column] )
Now you can also wrap either one of those in CALCULATE and add additional FILTERS...
Good Luck! :smileyhappy:
You normally get this generic Count Of... - when you drag a field (that is not data type number) to the Values area of your chart
What you need to do is write a Measure that duplicates this behavior.
You can then name it whatever you wish and use it in the Values area of your bar chart instead
Regarding which COUNT function to use - you'll have to tell us more what you want to count and how
In general COUNTROWS count all rows, COUNTA does not count blanks so...
COUNTROWS (Table) = COUNTA( Table[Column] ) + COUNTBLANK ( Table[Column] )
And if you need a distinct count you can use DISTINCTCOUNT ( Table[Column] )
Now you can also wrap either one of those in CALCULATE and add additional FILTERS...
Good Luck! :smileyhappy: