Forum Discussion
Learner22
Helper I
Helper ISumming 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 values of A and B (MeausureA =60 and MeasureB = 55).
How can I do this?
Many thanks best regards
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
1 Reply
- amitchandak
Super 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