Forum Discussion

vishnuteja's avatar
vishnuteja
Regular Visitor
4 years ago
Solved

Add Measure Column to Matrix

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 suggestio...
General Comment
Need Help
Show and Tell
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

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.