Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.