How to sum specific rows

[Anonymous]

Hi everyone!

I'm a new user of Power BI and am slightly stuck.

I have three columns. One is timestamp over a year, the other is a list of about 20 locations  and the last is all the values associated to the location at specific times. I am trying to create a measure to sum the values of one specific location. Can anyone help me with writing the measure please, I am getting used to DAX. So I need to do a SUM but filtered to one of the locations.

Thanks for your help!

[Ifmm]

Hi Everyone,

I have 3 columns: Month (January to December), customer number (up to 10000 different numbers) and Bought (1 or 0).

I'd like to have another column where I can see the total months the person worked. It will be repeated throught the rows for the same customer, and that's ok.

What would be the DAX?

Thanks

[themistoklis · Accepted solution]

@Anonymous

Create a measure like the followig one:

MEASURE =  CALCULATE(SUM('Table'[Values]), 'Table'[Location] = "London")