Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
3 years ago
Solved

Total not showing zero

Hi, I have a table with Plan, Actual and Gap columns. But, when plan and actual are equal, gap not showing as "0" and it is blank now. Can you help to support?   my Gap measure as below  ...
Need Help
  • Karthik12's avatar
    Karthik12
    3 years ago

    Ahmedx Hi, I have modified my Gap measure with below one and issue solved.

    Gap = VAR _gap = SUMX(VALUES('type'[type]), [Test MTD actual sum] - [Test MTD plan sum]) RETURN IF(_gap = 0, 0, _gap)

  • Karthik12's avatar
    Karthik12
    Post Patron
    3 years ago

    Ahmedx Hi, I have modified my Gap measure with below one and issue solved.

    Gap = VAR _gap = SUMX(VALUES('type'[type]), [Test MTD actual sum] - [Test MTD plan sum]) RETURN IF(_gap = 0, 0, _gap)