Forum Discussion

Celynx's avatar
Celynx
New Member
2 years ago
Solved

How to prevent a measure from being duplicated in each column when using a matrix in Power BI

Hi, hope you have a good day. Please your help with this, I have not been able to find the way to create this visual in Power BI and it seems to me quite simple. I have used the matrix where I can s...
help with matrix
Matrix table
Matrix Visual
  • lbendlin's avatar
    lbendlin
    2 years ago

    Read about HASONEVALUE  and then modify Measure A to produce a different result depending where in the visual you are.  You can rename the Column totals from "Total" to "Title Measure B"  .  No need for measure B.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Read about HASONEVALUE  and then modify Measure A to produce a different result depending where in the visual you are.  You can rename the Column totals from "Total" to "Title Measure B"  .  No need for measure B.

Celynx's avatar
Celynx
New Member
2 years ago

Thank you so much, that was exactly what i needed.