Measure to only show values when the first value appears (Chart)

[agd50]

How do I rewrite this measure so that it will only show the numbers from the beginning of when the values started?

[Anonymous · Accepted solution]

Hi @agd50 ,

I got an idea. It's to capture the first date which the value is over 0 and then leave the value less than its date blank and the rest the original values.

For example,

As required, the value should start in March and be 0 in February. Create the measure.

Measure = var _mindate=CALCULATE(MIN('Table'[Date]),FILTER(ALLSELECTED('Table'),[Value]>0))
return IF(MAX('Table'[Date])<_mindate,BLANK(),SUM('Table'[Value]))

Put the measure in the Y-axis, which starts in March.

Best Regards,

Stephen Tao

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