Summing values across rows using filter

[Learner22]

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

[amitchandak · Accepted solution]

@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

https://radacad.com/pivot-and-unpivot-with-power-bi