Slicer not filtering measure with constant value over date range

[Anonymous]

Hello,

I have a line chart with a Date as an axis and two measures for the values. One of the measures has formula "Ideal= 1" showing a horizontal line going through 1. The issue is that when I slice the date for a time interval, this measure "Ideal " is not sliced to show only the date interval. The first 2 images are the whole date range, the last 2 pictures are with the filter applied for November-December 2019. The "Ideal" line shows for the whole of 2019 when it shouldn't. Any thoughts?

[parry2k]

@Anonymous how does your measure looks like?

[Anonymous]

The measure is exactly :

Ideal = 1

[v-joesh-msft · Accepted solution]

Hi @Anonymous ,

You can try a measure similar to the following:

Ideal = IF(SUM(financials[ Sales])=BLANK(),BLANK(),1)

Or you can use constant line in Analytics:

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EUr8hleS3_JMsmaKgutMir4BmyhDusDJnQ-0i_Y9l9I2ZA?e=hgtd4l

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous so if your measure is value = 1 then it is going to show for all the month regardless how you filter it because your measure is always returning a value

[Anonymous]

I'm with a similar problem.

Can you guys take a little look?

Link: https://community.powerbi.com/t5/Desktop/DIVIDE-DAX-with-error-when-using-2-numerators/m-p/1933428