How to filter a set of rows without visual level filter

[Usefulinfo]

Hi All,

Need your help to solve below Query.

I have a measure which is created based on other existing measures.

Active_Form_ByEnd = ([Active_Form_BeforeDate] + [Form_Received_During_Period] ) - [Closed_Form_During_Period].

This is giving correct number of active Form but Its showing 0 for the [Closed_Form_During_Period] when used in visual(used Table visual).

Could you please suggest how to remove rows where the value is appearing 0 from the display for column [Active_Form_ByEnd]

Please note visual level filter is not applicable bcz I am using filed paramter to show dynamic table value for other measures as well.Hence, couldn't apply visual level fillter to remove 0 

Ex : you can see 0 value for form which is closed in April.

[Anonymous]

Hi @Usefulinfo ,

Please try to create a new measure.

MEASURE =
CALCULATE ( [Active_Form_ByEnd], FILTER ( 'Table', [Active_Form_ByEnd] <> 0 ) )

If that still doesn't solve your problem. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Usefulinfo]

@Anonymous ,Thank you for your reply.

I have tried this but didn't work. I will create a sample pbix file and share with you soon.

[FreemanZ]

hi @Usefulinfo ,

try like:

Active_Form_ByEnd =

VAR _result =

([Active_Form_BeforeDate] + [Form_Received_During_Period] ) - [Closed_Form_During_Period]

RETURN

IF(_result = 0, BLANK(), _result)

[Usefulinfo]

@FreemanZ , Thank you for you reply.

This will not work bcz it just replace 0 with blank but this row will be still visible in visual.

Could you please suggest anything else? 

[FreemanZ]

hi @Usefulinfo ,

does any these three measures ended with "+0", if so could they be removed? [Active_Form_BeforeDate] , [Form_Received_During_Period] ) , [Closed_Form_During_Period]

[Usefulinfo]

@FreemanZ ,No, all measures have 1 value.

[PhilipTreacy]

Hi @Usefulinfo 

So you just want the 0's to not be displayed?

You can do this by applying a custom format to the measure.

Select the measure and on the Ribbon, in the Formatting section type 0;0;; then hit Enter

Read more here -> Custom Formatting Strings in Power BI

Regards

Phil

[Usefulinfo]

@PhilipTreacy  Thank you for your suggesion. I tried this but didn't work.

I want to remove rows releted to 0 from display. Could you please suggest anything else.