Data did not aggregate

[Anonymous]

Hi,

I have a table with column Domain (Text), Date (Date), Time Range (Text) and Number of User Login (int).

The Number of User Login will aggregate in a bar chart by date. But it won't aggregate by Domain when i put it in table with slicer of date. The output is by domain and by time range. What has gone wrong here?

[Anonymous]

Hi @Anonymous

Logically your measure should aggregate with the dimension . Can you share some sample data and the formula you are using in the measure?

Thanks

Raj

[Anonymous]

@Anonymous, yes, it should be and I have tested yesterday and it was doing fine. But the table has changed when i opened it today. So I deleted the column in queries and undo the delete process and it has returned to normal now. 

Sorry that there was no sample data that i can share because the file has been overwritten.

[Anonymous · Accepted solution]

I redo the query and it works again.