topic Re: How to identify average when the column has text datatype? in DAX Commands and Tips

How to identify average when the column has text datatype?

Arioli_Chezhian — Sat, 11 May 2024 18:00:20 GMT

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

Re: How to identify average when the column has text datatype?

Pawasthi3292 — Sun, 12 May 2024 15:42:18 GMT

'Average of number of users'
Please elaborate, as in ,what should be output in case of your given scenario.

Re: How to identify average when the column has text datatype?

Arioli_Chezhian — Sun, 12 May 2024 16:17:49 GMT

Pawasthi3292 - As like average of distinctcount of number of users

Re: How to identify average when the column has text datatype?

Anonymous — Mon, 13 May 2024 06:15:18 GMT

Hi Arioli_Chezhian ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a measure

Distintcount = VAR _a = CALCULATE( DISTINCTCOUNT('Table'[Username]), ALL('Table') ) RETURN CALCULATE( COUNT('Table'[Username])/_a )

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly