Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to sum specific rows

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!

 

 

Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    Anonymous


    Create a measure like the followig one:

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

2 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    Anonymous


    Create a measure like the followig one:

    MEASURE =  CALCULATE(SUM('Table'[Values]), 'Table'[Location] = "London")
  • Ifmm's avatar
    Ifmm
    New Member
    5 years ago

    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