The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
52 | |
42 | |
27 | |
25 | |
23 |