Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
@bchager6 - 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.
@bchager6 - Thank you for your response.
Is it possible to get average of distinctcount instead of count?
Try replacing COUNTA with DISTINCTCOUNT
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |