Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to 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
@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
User | Count |
---|---|
17 | |
14 | |
14 | |
13 | |
12 |
User | Count |
---|---|
19 | |
15 | |
15 | |
11 | |
10 |