Matrix, Filter a measure, show items with no values per category

[Scholes]

Hi,

I have a simple measure which is: 

Actuals rent M-1 VV = CALCULATE([Income VV],DATEADD(Kalender[Datum],-1,MONTH))

When showing this in a matrix with the condition that also items with no values are shown. I get the below result.

I need now that the measure will only show for category A the values which are not blank = ZEROS. For category B I want to see the BLANKS and ZERO values.

[Scholes]

 Hi thanks for the help. The measure works but the only thing is I also want to  see A 3 which is zero. This value is now not shown.

Update: I figured out this could easily be resolved by 

&& ISBLANK([Measure])

[Anonymous · Accepted solution]

Hi @Scholes ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a measure

Measure = 
IF(
    SELECTEDVALUE('Table'[Category]) = "A" && SELECTEDVALUE('Table'[Value]) = 0,
    0,
    1
)

Set the category as show item with no data

Apply the measure to th matrix filter and set it as 1

Final output

Best regards,
Albert He

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