Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 .
Solved! Go to 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.
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.
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.
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.