Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have a column which has 'user name' and it's datatype is 'text'. Currently I am showing the data in card visual which shows distinctcount of username.
However, I would like to show 'Average of number of users'. Since it is in text datatype, could you please advice on how to write the measure to achieve this scenario?
E.g. data:
Username |
abc |
def |
ghi |
Solved! Go to Solution.
@Arioli_Chezhian This measure for example will calculate the average number of products, year over year. I recommend trying quick measures to learn things like this.
@Arioli_Chezhian What would your average be based on? For example, average number of users over time or average sales by user.
@Anonymous - In a card visual, just need to show the Average of number of users. May be you can consider as average number of users over time.
@Arioli_Chezhian This measure for example will calculate the average number of products, year over year. I recommend trying quick measures to learn things like this.
@Anonymous - Thank you for your response.
Is it possible to get average of distinctcount instead of count?
Try replacing COUNTA with DISTINCTCOUNT
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |