added into sum but not shown in the visual

[Anonymous]

Hi guy, I met a problem like this:

   This is a matrix visual, when dim1 is null, I need the null value is not shown in the visual(the row that dim1 is blank  should not shown), but the value of null is required to add to ’Total‘.

 Do you have any good ideas? Thank you.

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Please try the following measure:

SumTarget = 
IF (
    NOT ( ISFILTERED ( 'Table'[dim2] ) )
        || MAX ( 'Table'[dim2] ) <> BLANK (),
    SUM ( 'Table'[Target] )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,is such a case it is better to use a visual level filter to remove the blank dim value.

But better you find why there is the null value. Is dimension having null values for that column, Or it is because of missing values in dimension and fact has those

[Anonymous]

If I use filter to remove null value, the value correspond to it would not added to total.

I need to add the value of  Target column to 'total' when dim2 is null, but the null value of dim2 should not be shown, is there to be any suggestion?