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 =
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.
Need Help
Tips and Tricks

3 Replies

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