I calculating a value using a measure (let say the measure name is [event_value]). I have a column in the table which assigns a unique value to a half-hour block. I called that column Epoch Half Hour Number. I want to create a measure that sum-up all the [event-value] that occurred in the same Epoch Half Hour Number. I create measure as follow:
Sum same Epoch number =
var Time30Min = MAX(‘Table’[Epoch Half Hour Number])
SUMX(FILTER(‘Table’,‘Table’[Epoch Half Hour Number]=Time30Min),
The above measure produces the following output:
The output does not sum up the event_value with the same Epoch Number. I have highlighted in red colour. Could anyone help me where am I making the mistake?