Summing the rows of multiple columns with filter

[Anonymous]

Hi. I currently have a table that displays decimals for each particular day. What I'd like to do is summarize each of these days, filtered by the Resource#.

The desired output would be a table that displays each sum per Day# according to its resource (as below).

My initial idea was to use CALCULATE, SUM and FILTER to each column individually, but I constantly receive circular dependency errors. Is there a better way to go about doing this?

CALCULATE(SUM(Sub_Table[Day#15]),FILTERS(Sub_Table[Resource#]))

Thank you for the input!

[v-yuta-msft · Accepted solution]

@Anonymous ,

Create three measures using DAX below and drag them to the table visual:

Day# 15_ = CALCULATE(ROUNDUP(SUM('Table'[Day#15]), 0), ALLEXCEPT('Table', 'Table'[Resource#]))
Day# 16_ = CALCULATE(ROUNDUP(SUM('Table'[Day#16]), 0), ALLEXCEPT('Table', 'Table'[Resource#]))
Day# 17_ = CALCULATE(ROUNDUP(SUM('Table'[Day#17]), 0), ALLEXCEPT('Table', 'Table'[Resource#]))

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Omega]

Change data type of Reasource# to Text and then drag your measures 🙂