Forum Discussion
mesuare in total
I need measure 3 to take the information from the column mesuare 1(1,2,3) but the total of this measure take the total of measure 2 (12) I don't know how to do it ....
| Letter | measure 1 | measure 2 | measure 3 |
| a | 1 | 2 | 1 |
| b | 2 | 4 | 2 |
| c | 3 | 6 | 3 |
| Total | 6 | 12 | 12 |
Hi, Anonymous
Please check the below picture, measure, and the sample pbix file's link down below.
Measure 1 =SUM(Data[measure 1])Measure 2 =SUM(Data[measure 2])Measure 3 =IF( ISINSCOPE(Data[Letter]), [Measure 1], [Measure 2])Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
1 Reply
- Jihwan_Kim
Super User
Hi, Anonymous
Please check the below picture, measure, and the sample pbix file's link down below.
Measure 1 =SUM(Data[measure 1])Measure 2 =SUM(Data[measure 2])Measure 3 =IF( ISINSCOPE(Data[Letter]), [Measure 1], [Measure 2])Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.