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] )
)

[afrutos]

Thanks works perectly!