Measure to display zero if the filter in the formula is unselected in the page

[AliceW]

Hi folks,

Seems pretty simple, but I can't figure it out.

So, I have this measure.

Lost Opps =

calculate(

[Lost Opps],

Opp[Lost Reason] = "Duplicate"

)

In the report page, I have the filter 'Lost Reason'. I'd like the measure to display zero if 'Duplicate' is unselected in this filter.

How do I do that, please?

Thanks,

Alice

[MFelix]

Hi @AliceW ,

Try the following code:

Lost Opps =
COALESCE ( CALCULATE ( [Lost Opps], Opp[Lost Reason] = "Duplicate" ), 0 )

[AliceW]

Thanks for replying, Miguel. Does not work, sorry...

[MFelix]

Hi @AliceW ,

Can you please share a simple mockup file data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[AliceW · Accepted solution]

Hi Miguel,

I just ended up doing a new column, which solved my problem.

Thanks for your time!