Forum Discussion

ReutAtias12's avatar
ReutAtias12
Frequent Visitor
3 years ago
Solved

Count total client base on condition

Hi All,   I'm trying to count the amount of times a client login with the same user and then count the total client that had only one user in three months    client id login date user 1 ...
COUNT
DAX
Power BI Dax
SUMMARIZE
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure how your datamodel looks like, or how your desired outcome of the visualizations look like, but please try something like below and the attached pbix file.

     

     

    Expected result measure: =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            DISTINCT ( Data[client id] ),
            "@countusers", CALCULATE ( COUNTROWS ( DISTINCT ( Data[user] ) ) )
        ),
        [@countusers] = 1
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I am not sure how your datamodel looks like, or how your desired outcome of the visualizations look like, but please try something like below and the attached pbix file.

 

 

Expected result measure: =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            DISTINCT ( Data[client id] ),
            "@countusers", CALCULATE ( COUNTROWS ( DISTINCT ( Data[user] ) ) )
        ),
        [@countusers] = 1
    )
)
  • ReutAtias12's avatar
    ReutAtias12
    Frequent Visitor
    3 years ago

    Thanks that works!