Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
@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.
Change data type of Reasource# to Text and then drag your measures 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |