Show row but hide the value in a table

[ArthurGuyard]

Hello,

For a report I have list of material with different level.

For exemple to build the PU00322 I have to use the A000933, and i have that on 5 level.

In my report I want to show the missing componenent. For each item I calulate the need ( customer order quantity) and I do stock - need. If it is negative we are missing some item so we want to display the item.

In my example the PU00322 have -1580 ( we allow negative stock haha) in stock and a need of 190, so the cover LVL1 will be -1770 so we want to display the line( and it is working).

To specify  we use a filter on the visual ( if coverLVL1 <0 we display).

Now if we go to the lvl 2.

To build the PU00322 we have to use the A000933, we have a stock of 6113.40 and a need of 19, so the cover is 6114.40.

As it is above 0 this need to be hidden.

If I apply a filter on the visual saying "show cover LVL2 < 0 " it will hide the entier line and the value only.

My question is how can we hide the values of the A000933 witout removing the row. Because we still want to display the fact that we miss the PU000322 ?

Below the image. the first on is with a filter on the visual only on LVL 1 and the second image is when I had a visual filter on lvl 2 saying if >0 display ( or empty)

Thank you for your help !

[v-zhangti]

Hi, @ArthurGuyard 

Can you provide a simple PBIX file for testing? Sensitive information can be removed in advance. If you can, please show the output you expect with your screenshot. Looking forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more.

[ArthurGuyard]

I tried a workaround using measure. For the A000933 I created a measure saying 

Item NV2 =

var valeur =SELECTEDVALUE(Resultat[component]) => 

return if([Couverture NV1]>=0,BLANK(),if([Couverture NV2]>=0,BLANK(),valeur))

That way it display a blank.

unfortunatly for some resons it break the other mesure for thr cover and couln't figure it out !

Do you guys have any idea how to handle this ?

bR

Arthur