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

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