Forum Discussion

Braunnz's avatar
Braunnz
Frequent Visitor
4 years ago

Weird matrix behaviour when average time measure is added.

I have a matrix to show the average time of when a bus arrives at a stop. I've used this measure before and had no issue:

AvgTime = FORMAT(AVERAGE('Table'[Act. time]), "hh:mm")
 
For this particular matrix though, adding the measure gives blanks for not just the time measure, but another measure that behaved normally before. It also breaks other fields, which I'll explain below.
 
If I adjust the AvgTime measure to not have the format, the decimal values appear just fine.

Before adding the measure:

 

After adding the measure:

Note that the fields following route are not correct for #6, so I'm extremely confused as to why adding this measure breaks everything, especially since the unformatted variant works just fine. 

Everyone one of those fields comes from the same source table.

Any idea what my issue might be?

 

EDIT: 
Digging deeper I realized that the correct values are deep within the matrix when the fields are actually valid for the route in question... so fundamentally the question is how to I prevent this invalid rows from appearing.

Need Help

1 Reply