Forum Discussion
Learner22
3 years agoHelper I
Summing 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...
- 3 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
3 years agoSuper User
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