Forum Discussion

SBC's avatar
SBC
Icon for Helper III rankHelper III
2 years ago
Solved

Issue with Displaying Correct Subtotals in Matrix Visual

Hello, I'm seeking assistance with a matrix visual in Power BI where I need to use a specific column as a value without aggregation. Despite my efforts, the subtotals are not displaying as expected....
"dax code"
"DAX help"
@need help
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi SBC 

    I am not sure if this meets your requirement, but I thought as the selectedvalue is a syntax suger for if-hasonevalue-values, if you put the sum in the if conditional branch, you can get the total for the values where the values are multiple.  

    Best regards,

SBC's avatar
SBC
Icon for Helper III rankHelper III
2 years ago

Hi DataNinja777 ,                                                                                                                      Thanks for your response. I tried using SUMX as you suggested, but unfortunately, it didn't work as expected. I'm still getting the same values and the subtotals are not calculating correctly.Could you please provide further guidance or an alternative solution?                                                                

 Thanks again for your help.

 

Regards,

SBC

 

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
2 years ago

Hi SBC ,

You are right.  It shows zero even with sumx.  Is there any reason why you have to use selectedvalue?  Is it not sufficient to use the usual sum function for 'Table_2'[(0-1)]?  

 

Best regards,

  • SBC's avatar
    SBC
    Icon for Helper III rankHelper III
    2 years ago

    Hi DataNinja777 ,

    Thanks for your question! I'm using SELECTEDVALUE because I need to display the exact values from the '0-1' column in a matrix visual without any aggregation. Directly placing the column in the value field defaults to aggregation like sum or max, which isn't suitable for my needs. By converting the column into a measure using SELECTEDVALUE, I can control the output to show individual values as they are. The measure ensures that if there's no value selected, it returns 0, maintaining consistency in the visual display.

    However, I'm facing an issue where I can display the values correctly, but I'm unable to sum these values across the visual.

    Any suggestions on how to achieve this would be greatly appreciated!

     

    Best,
    SBC