Summarized Table

[Kurt4597]

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

[mangaus1111 · Accepted solution]

Hi @Kurt4597 ,

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

[mangaus1111]

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]

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