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,

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
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,