Why do two metrics appear in each column of my matrix?

[Yumikang]

Dear all,

I desperately need everyone's help, it's been bothering me for a long time.

Question 1: Why do two metric values appear in each column of my matrix?

Am I setting up the matrix correctly this way?

Question 2: Why is the last total row of my OT, a metric, not equal to the sum of the OT of each row in the matrix?

Here are some of my metric DAX formulas:

1、

OT = SUMX(

    VALUES('date'[yearmonth]),

    VAR MonthHours = CALCULATE([total])

    VAR MonthStd = CALCULATE([ST])

    RETURN

    IF(MonthHours > MonthStd, MonthHours - MonthStd, 0)

)

2、

total =

CALCULATE(

    SUM('2025'[time1]),

    CROSSFILTER('date'[yearweek], 'time'[time], BOTH)  

)

3、

ST=

VAR SelectedMonth = SELECTEDVALUE('日期表'[月])

RETURN CALCULATE(

    VALUES('2025ST'[STTIME]),

    FILTER('2025ST', '2025STTIME'[MONTH] = SelectedMonth)

)

There is an urgent need for everyone's help.

[v-sdhruv]

Hi @Yumikang ,
I hope the issue was resolved. If the explaination has helped to answer your query, then please mark it "Accept as Solution" so that other users can benefit from it.
If you still need assistance, please feel to reach out.
Thank you for being a part of this community.

[v-sdhruv]

Hi @Yumikang ,
I hope the issue was resolved. If the explaination has helped to answer your query, then please mark it "Accept as Solution" so that other users can benefit from it.
If you still need assistance, please feel to reach out.
Thank you for being a part of this community.

[v-sdhruv]

Hi @Yumikang ,
I hope the issue was resolved. If the explaination has helped to answer your query, then please mark it "Accept as Solution" so that other users can benefit from it.
Thank you!

[SamanthaPuaXY]

Hi @Yumikang ,

Unfortunately that's the constraint of using the matrix visual. You can consider using a table visual or having 2 matrix to represent what you need.

Hope this helps

[Yumikang]

Q2 have solved，please help Q1.

[SamanthaPuaXY]

Hi @Yumikang 

In your visual, you are specifying 2columns hence it's showing for all columns. You can remove to show which is the one that you want to show.

Please do give a kudos if it solves the problem. thanks!

[Yumikang]

thanks.but I need to show the OT on the far right side of the matrix, just not in every column.