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 as...
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")
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