topic need help in DAX Commands and Tips

need help

MSAYED26 — Mon, 24 Jun 2024 12:29:33 GMT

Hello, I want to the chart continue the line to today , there is no value make it equal zero like chart below

Re: need help

aduguid — Mon, 24 Jun 2024 12:35:23 GMT

Add +0 to the end of your measure.

Your Measure = SUM('Table'[Value])+0

Re: need help

Anonymous — Tue, 25 Jun 2024 03:10:13 GMT

Hi MSAYED26 ,

Thanks for the reply from aduguid , please allow me to provide another insight:

You can try this.

Measure = IF(SUM('Table'[value]) = BLANK(), 0, SUM('Table'[value]))

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

Re: need help

MSAYED26 — Tue, 25 Jun 2024 06:47:53 GMT

Thanks for your help ,but i have target line change every qtr not equal zero .

Re: need help

Anonymous — Tue, 25 Jun 2024 08:20:03 GMT

Hi MSAYED26 ,

Sorry, I don't quite understand what you are looking for, can you add more description so we can better understand your problem?

Also, 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 this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: need help

MSAYED26 — Tue, 25 Jun 2024 09:21:32 GMT

Thanks for your time, in count value that cell equal zero and ppm equal zero the target still have value ,so i want the target line continous have value not zero like green line .

	Count	PPM	Target
May-21	2	210	166
Jun-21	1	75	166
Jul-21	2	190	166
Aug-21	6	748	166
Sep-21	0	0	166
Oct-21	3	179	166
Nov-21	1	62	166
Dec-21	3	412	166
Jan-22	0	0	166
Feb-22	0	0	166
Mar-22	0	0	166
Apr-22	0	0	166
May-22	0	0	166
Jun-22	0	0	166
Jul-22	0	0	166
Aug-22	0	0	166
Sep-22	0	0	166
Oct-22	1	40	166