Add Measure Column to Matrix

[vishnuteja]

I Just need to add only one measure at the end of Matrix but Measure is adding to each Column in the Matrix,

I tried the work-around with word-wrap but is there any other solution or suggestions . 

[v-zhangti]

Hi, @vishnuteja 

If the previous suggestions didn't solve your problem, can you provide a simple PBIX file for testing? And show what you expect the output to be. Looking forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-zhangti · Accepted solution]

Hi, @vishnuteja 

Are you trying to control the Total of the Matrix view using Measure? If this is the case, you can learn about the HASONEVALUE function. https://docs.microsoft.com/dax/hasonevalue-function-dax 

As an example, for the data shown in the figure, total defaults to sum, but I want to display the smallest value of it.

Measure = IF(HASONEVALUE('Table'[Sales]),SUM('Table'[Sales]),MIN('Table'[Sales]))

If the method I provided above can't solve your problem, what's your expected result? Can you provide a simple PBIX file for testing?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Leave the Column well empty, and only use the Values well. Consider using a table rather than a matrix. Consider using calculation groups. Consider creating a completely custom matrix.