Forum Discussion

Kurt4597's avatar
Kurt4597
Helper I
3 years ago
Solved

Summarized Table

Sales Table

 

Date Table

 

I would like to create a summarized table like this 

 

 

I am able to create a summarized table for each day using the following code

DailySalesCount = SUMMARIZECOLUMNS(DateDim[Date],"DailyClickCount",DISTINCTCOUNT(Sales[Unique Sale Reference]))
But I am unable to bring the Shop name into this

 

Please could somebody assist? 

 

Sample File https://easyupload.io/bx07gx

 

Thank you

 

 

Need Help

3 Replies

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    Hi Kurt4597 ,

     

    try this:

     

    ADDCOLUMNS(

                           SUMMARIZE(

                                               'Sales Table',

                                                'Date Dim'[Date],

                                               'Sales Table'[Shop Name]

                                              ),

                           "DailyClickCount",DISTINCTCOUNT(ClicksByDay[clickref])

    )

    Please mark this answer as solution, if it helps.

     

     

    • Kurt4597's avatar
      Kurt4597
      Helper I
      3 years ago

      Hello, I appear to get this error message from your solution

       

       

       

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    Hi Kurt4597 ,

     

    you have to create a table, instead of a column. Try this new script: