Matrix percentage values changes to zero if those values are outside of filtered upper boundary

[Anonymous]

Hi all,

my matrix looks like this. these are percentage value range from 0% to 100%.

but when I change the percentage value (upper limit) 100% to 79%, all the values greater than 79% changes to 0% instead filtering the rows or showing as blank. (as seen in below)

This gives incorrect insight because there are rows which are originally zero.

But when I change the lower boundary it filters the rows by hiding the rows or showing blank cells with values outside the limits.

My reqirement is to filter the rows or to show blank when I change only the upper limit while keeping lower limit at zero. Is there a way to do that?

thanks

[lukiz84]

Hi,

please post the measure you use in the matrix

br

[Anonymous]

Hi,

I have used code coverage percentages for several projects for weekly data. Even though fetched data are percentage vaues, I had to devide them by 100 and change the format to percentage in order to show the '%' sign in the cell along with the value.

"Coverage Value = (IF('Measures Dimension'[Metric Type]="coverage", 'Measures Dimension'[Metric Value],0)/100)"

br

[lukiz84 · Accepted solution]

and you are certain that those values that are 0 afterwards have type coverage? because your measure results in 0 in every other case (other than coverage)

[Anonymous]

You are correct. That is the issue. I used a blank instead of zero in the measure. that solved the issue.

much appriciate your support. 🙂

BR

[lukiz84]

you are welcome, please mark my answer as solution 🙂