Forum Discussion

Arioli_Chezhian's avatar
Arioli_Chezhian
Icon for Helper II rankHelper II
2 years ago
Solved

How to identify average when the column has text datatype?

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 'A...
"Need Help"
"Tips and Tricks"
General Comments
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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