how to count the number of values in a coulmn

[MostafaGamal]

Hi all, 

If i have a table like the one in attached, i want to count the values in the column "entries" but count only one value for each user in coulmn " user mail " , How to do that ?? 

[v-yingjl · Accepted solution]

Hi @MostafaGamal ,

You can choose to create a measure like this:

Measure = 
CALCULATE (
    SUM ( 'Table'[Entreirs] ),
    ALLEXCEPT ( 'Table', 'Table'[User Mail] )
)

In addition, if you want to show the result in the table, you can put the [User mail] and [Entreris] column in the table to get the same result without creating any measure.

Best Regards,
Yingjie Li

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

[parry2k]

@MostafaGamal you can use distinctcount DAX function

Distinct User = DISTINCTCOUNT ( Table[User] ) 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[MostafaGamal]

@parry2k i want to sum the values in column " entries " but only in one row for each user Mail 

[parry2k]

@MostafaGamal 

Measure = SUMX ( VALUES ( Table[User] ), CALCULATE ( MAX ( Table[Entry] ) ) )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡