What the error in the below Measure?

[ssspk]

Hello Team,

What could be the reason for the below error in the Measure?

Do i need to create new Measure for ClickCount and Unique User? 

DAX:

_UniqueClicksPerDay_EventsPerUserPerDay =

SUMMARIZE(

    ADDCOLUMNS(

        GROUPBY(

            SUMMARIZE(

                'data',

                'data'[servertime],

                'data'[user],

                'data'[appid],

                "ClickCount", COUNTROWS('data')  -- Renamed to ClickCount

            ),

            'data'[servertime],

            'data'[appid]

        ),

        "ClicksCount", SUMX(CURRENTGROUP(), 'ClickCount'),

        "UniqueUsers", SUMX(CURRENTGROUP(), 1)

    ),

    'data'[servertime],

    'data'[appid],

    "UniqueClicks", [ClicksCount] / [UniqueUsers]

)

Thank you.

[Kishore_KVN]

Hello @ssspk ,

Reference given for SUMX is wrong because syntax of SUMX is as follows:

SUMX(<table>, <expression>)
So please correct it accordingly. Else explain your requirement with sample data and we will try to provide solution. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[ssspk]

Hello @Kishore_KVN ,

Thank you for your reply,

My Requirement is ,

Find 'Unique users per day'.

I have a

table name: data

column:servertime

column:user

column:appid

This is my python code,

events_per_user_per_day = all_events.groupby([pd.Grouper(key='servertime', freq='D', label='left'), 'user'])[['appId']].count()
f = events_per_user_per_day.groupby(level="servertime").size().plot()

How to convert this to DAX Query Measure?

Thanks 

[Kishore_KVN]

Hello @ssspk ,

You can use below calcuation:

Unique Users Per Day = 
CALCULATE(
    DISTINCTCOUNT('data'[user]),
    ALLEXCEPT('data', 'data'[servertime])
)

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!