SHOW TOTAL COLUMN ON FIRST POSITION IN MATRIX

[afrutos]

Hi everyone ,

Is there any way to move the total column, so that instead of being on the right, it is on the left?
I can't find any information

Thanks

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file to demonstrate what is an alternative way.

Please check the below picture and the attached pbix file.

I am not sure how your datamodel looks like, but I hope the below can provide some ideas on how to create a solution for your datamodel.

Sales total measure: =
IF (
    SELECTEDVALUE ( Country[Country] ) = "Total",
    CALCULATE ( SUM ( Data[Sales] ), ALL ( Country ) ),
    SUM ( Data[Sales] )
)

[Pawan_123]

It will only work if one is not using any field in columns section of matrix visual. I have a field added in columns and few fields added in rows which is been used for drill down in proper heirarchy. Using different kinds of measures in values. 
When using columns for the specific visual column subtotal is generated and you will have Total section which displays all the measures under it along with other column headers. Moving column subtotal to front will not work if we are using columns in matrix visual.

[afrutos]

Thanks works perectly!

[Pawan_123]

@afrutos and @Jihwan_Kim 

The solution suggested above won't work with complex data model it seems. I am using matric visual in report which is using three fields in rows for drill down and in columns am using a field and using different measures in values but to create the custom measure as suggested above will not work properly?