Matrix visual: remove rows where status equal 100%

[jgaard]

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 problems. The percentage is calculated by the visual, Show Value as -> Percent of Row Total

Example Matrix of what I have:

	Failed	Installed	Not installed	Pending
Software A		100%
Software B	3.77%	90.57%		5.66%
Software C	0.48%	97.58		1.93%
Software D		100%

Example Matrix of what I would like:

	Failed	Installed	Not installed	Pending
Software B	3.77%	90.57%		5.66%
Software C	0.48%	97.58		1.93%

Is it possible? 

[Ahmedx]

Share sample pbix file to help you.

[jgaard]

Sorry I did not see this answer. 

https://drive.google.com/file/d/1tD_vZr4AjD0VKGlAKLd9lnUiBaZsAHHA/view?usp=sharing

I just want ro remove/hide the rows where 100% is installed. 

[Ahmedx · Accepted solution]

Sample PBIX file attached

https://1drv.ms/u/s!AiUZ0Ws7G26Rh3rwG8xf-ul7WTHB?e=nFaJ3l

[Ahmedx]

you can write like this

IF( [Installed] >= 1, BLANK(),[Installed] )

[jgaard]

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. 

[jgaard]

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