Forum Discussion

ssspk's avatar
ssspk
Icon for Helper III rankHelper III
2 years ago

What the error in the below Measure?

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 = SU...
Need Help
Tips and Tricks
ssspk's avatar
ssspk
Icon for Helper III rankHelper III
2 years ago

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's avatar
Kishore_KVN
Icon for Solution Sage rankSolution Sage
2 years ago

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!!