Karthik12Post Patron3 years agoSolvedTotal not showing zeroHi,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] )Karthik12 to Ahmedx3 years agoAhmedx 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 to Ahmedx3 years agoAhmedx 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 to Ahmedx3 years agoAhmedx 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)
2 RepliesReplies sorted by Most LikedAhmedxSuper User3 years agopls see this videohttps://www.youtube.com/watch?v=AZBGRo3FJ5c&t=406s&ab_channel=PeryTUS-PowerBIHowToKarthik12Post Patron to Ahmedx3 years agoAhmedx 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)
AhmedxSuper User3 years agopls see this videohttps://www.youtube.com/watch?v=AZBGRo3FJ5c&t=406s&ab_channel=PeryTUS-PowerBIHowTo
Karthik12Post Patron to Ahmedx3 years agoAhmedx 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)
Related contentTotal % not showing correctlyAdjust this measure to show totalsTotal measures show wrong total when report is publishedShow Measure Only in Totals in MatrixHow to show % of total in Power BI Matrix
