calculate sum of a measure based on category

[Suryaann]

Hi All,

I have table whose structure is like below:

Date               Date1                VALUE

4/2/2019        1/1/2019              10

4/2/2019        2/1/2019              40

4/2/2019        3/1/2019              10

5/2/2019        1/1/2019              70

5/2/2019        2/1/2019              80

5/2/2019        3/1/2019              80

i Want to create a measure which will sum the value for each set of date field.

for 4/2/2019 sum(Value)=60.

I am using direct query.So calculate is not supported i think.

Kindly help.

[Anonymous · Accepted solution]

@Suryaann - There is no such limitation. You do want to test measure performance as you increase complexity. Have you tried something like the following Measure?:

Your Measure = 
CALCULATE(
    SUM(YourTable[Value]),
    ALL(YourTable[Date1])
)

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.