Forum Discussion
need help
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.
Thanks for your help ,but i have target line change every qtr not equal zero .
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.
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