Seek help on correct my YTD Diff expression

[Anonymous]

Hi All

I need it for create gauge chart %.

[amitchandak]

@Anonymous , Create measures. You are creating column.

The other three also should be measure

[Anonymous]

Hi Amit

I created at meansure , still return zero.

[amitchandak · Accepted solution]

@Anonymous , LYTD - LYTD

Please change to

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

[Anonymous]

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