Forum Discussion

jgaard's avatar
jgaard
Frequent Visitor
3 years ago
Solved

Matrix visual: remove rows where status equal 100%

Hi    I have a Matrix visual that displays different Software in installation states. If 100% is installed I would like for the row to be removed from the visual, making it easier to focus on the p...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago

you can write like this

IF( [Installed] >= 1, BLANK(),[Installed] )
jgaard's avatar
jgaard
Frequent Visitor
3 years ago

I figured out that I need to do a measure, I should have known that. 😉 

But it comes up with an error, "The value for 'installed' cannot be determined. Either the column doesn't exist, or there is no current row for this column." 
Does this error occur because my Matrix comes from the values of "installState" and not from it's own column.