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
Icon for Super User rankSuper User
3 years ago

you can write like this

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

    Where excatly would I write that? I'm not that well into Power BI (but trying to get there).

     

  • 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.