Seek help on correct my YTD Diff expression

[Paulyeo11]

Hi All

I need it for create gauge chart %.

[amitchandak]

@Paulyeo11 , Create measures. You are creating column.

The other three also should be measure

[Paulyeo11]

Hi Amit

I created at meansure , still return zero.

[amitchandak · Accepted solution]

@Paulyeo11 , LYTD - LYTD

Please change to

Divide([YTD Sales]-[LYTD Sales],[LYTD Sales])

[Anonymous]

@Paulyeo11  you seem to enter wrong measure (LYTD-LYTD) gives you 0 always .Kindly correct that