Matrix Visualization not showing all the data unless the row is shorted

I added a zero into the one sum formula, but it seems like a poor patch to fix the issue, and I don't seem to have the issue with the other two reports. However, as mentioned, those other two reports have larger data sets. 

ReasonCode Sum =

VAR Total_Hours =

SUMX(

'Reason Codes',

HOUR('Reason Codes'[AGENTSTATETIME])+ MINUTE('Reason Codes'[AGENTSTATETIME])/60 + SECOND('Reason Codes'[AGENTSTATETIME])/3600

)+0

Var HoursTotal = (Total_Hours)

Var HoursInt = TRUNC(HoursTotal)

Var MinutesTotal = (HoursTotal - HoursInt)*60

Var MinutesInt = Trunc(MinutesTotal)

Var SecondsTotal = Round( (MinutesTotal - MinutesInt)*60,0)

RETURN

FORMAT(HoursInt,"00")&" "&FORMAT(MinutesInt,"00")&" "&FORMAT(SecondsTotal,"00")&" "

 

 

Hi, Anonymous 

Since you mentioned that the issue doesn't appear in other reports with larger datasets, it's critical to double-check the data model and relationships, especially between the agent name table and the data table. Make sure that the relationship settings are consistent across all reports.

In the columns section of the visualization, if the agent name is a text column and it affects data visibility, consider reviewing the configuration of the matrix visual. Specifically, see how to use the Agent Name field in the Rows or Columns area of the matrix. For more insights into configuring the matrix visual, see the links below:

Create a matrix visual in Power BI - Power BI | Microsoft Learn

If the issue persists, explore the visibility and formatting options for the matrix visual. Sometimes, adjusting the visibility settings or the format and display of the data can help resolve issues related to data not being displayed as expected.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.