Forum Discussion
Learner22
Helper I
4 years agoSumming values across rows using filter
Dear community, image I have the following table Goal 2020 2021 2022 A 10 20 30 B 5 10 40 I want to have to two meausures summing the...
- 4 years ago
Learner22 , if this is a data table, you need a measure and display that with the goal
Sumx(Table, [2020], [2021], [2022])
You can unpivot the table , then you can simply sum the value part
amitchandak
Super User
4 years agoLearner22 , if this is a data table, you need a measure and display that with the goal
Sumx(Table, [2020], [2021], [2022])
You can unpivot the table , then you can simply sum the value part