Forum Discussion
Solved
Show measures in matrix based on row value
Hi, I have two measures A and B.
| Name | A | B |
| John | 3 | 9 |
| Mary | 5 | 12 |
| Mika | 8 | 15 |
I need solution, when name is Mary then value = measure B, when other rows then measure A.
| Name | Value |
| John | 3 |
| Mary | 12 |
| Mika | 8 |
I've been tried different measures but no luck so long.
peedik , a new measure
if(Max(Table[Name]) = "Mary", [Measure B], [Measure A])
or
Sumx(Values(Table[Name]), calculate(if(Max(Table[Name]) = "Mary", [Measure B], [Measure A]) ) )
1 Reply
- amitchandak
Super User
peedik , a new measure
if(Max(Table[Name]) = "Mary", [Measure B], [Measure A])
or
Sumx(Values(Table[Name]), calculate(if(Max(Table[Name]) = "Mary", [Measure B], [Measure A]) ) )