Total not showing zero

[Karthik12]

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

Gap=

IF(

    [Plan] = [Actual],0, [Gap]

    )

[Ahmedx]

pls see this video

https://www.youtube.com/watch?v=AZBGRo3FJ5c&t=406s&ab_channel=PeryTUS-PowerBIHowTo

[Karthik12 · Accepted solution]

@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)