add up values based on half an hour

[Dunner2020]

Hi there,

I have three tables: date, time, and customer information (sample file can be found here https://1drv.ms/u/s!AucycxZHFe9TjS6G96JVtgslQLBX?e=hDipug  ). Data model is shown in the picture:

I calculated a measure (named Result) using date, time, and customer information table (as shown in the picture).

Now I want to create another measure, which summed up the value of the Result measure if it happens in the same half an hour. I tried with groupby but it throws an error. Any help would be really appreciated 

[amitchandak]

@Dunner2020 , what us formula not working. I looked at the file. Did not find one with the error. Also, I just removed the time column and just kept half hour only.

[Dunner2020]

@amitchandak Sorry I did not save the file before uploading the file, that's why did not show the error.  I have updated the file.

[amitchandak]

@Dunner2020 , You do not to aggregate again 

SUMX(VALUES(Times[Half Hour]),[Result])

But I think you are looking for all except 

calculate([Result],allexcept(Times[Half Hour]))

[Dunner2020]

@amitchandak , I tried both formulas you mentioned in your last reply.

I created a new measure using formula SUMX(VALUES(Times[Half Hour]),[Result]) and also removed the time column but kept half an hour field in the visualisation. However, it did not sum up by half an hour. Results are shown in the picture:

Then I created another measure using this formula   calculate([Result],allexcept(Times,Times[Half Hour]))

However, it also produced the same result. Means did not sum up result value based on half an hour.

[amitchandak]

@Dunner2020 , Separate Date and time and create a time table

Time = [Date].time

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

[Dunner2020]

Time table is already populated. I couldnt see the reason of creating another one.