DIVIDE Measure Creating Blank Rows

[delish68]

I have a calculation item that returns "change" or "growth" by subtracting prior year from current year and then dividing that by prior year. Pretty standard calculation. The problem is that when I add this to my matrix, it returns a bunch of empty rows.

FORMAT (DIVIDE (CALCULATE ( SELECTEDMEASURE (), 'Time Intelligence'[Time Calc] = "YTD" ) - CALCULATE ( SELECTEDMEASURE (), 'Time Intelligence'[Time Calc] = "PYTD" ),
CALCULATE ( SELECTEDMEASURE (), 'Time Intelligence'[Time Calc] = "PYTD" )), "Percent")

This is what it looks like without the calculation item:

And this is what it looks like when I add the growth calculation item:

It looks like it has to do with the FORMAT function. If so, is there a way to format this as a percent without the function returning a bunch of blanks and expanding this matrix unnecessarily?

[delish68]

This seemed to resolve my issue but not sure if it's the most elegant approach.

[Anonymous]

Hi,@delish68 .

If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,@delish68 Hello,@aduguid ,thanks for your concern about this issue.
Very glad to see that you have found a suitable solution and shared it, I think the dax code you have given is easy to understand and is a good solution.
Thank you for sharing it as it will help more users on the forum who have similar problems.
You can mark your own suggestions as solutions.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian

[aduguid]

Have you tried using the ribbon to format the measure as a percent?

[delish68]

I don't believe that can be done with Calculation Groups/Items.