Generateseries with a percentage

[Anonymous]

Hi all, I'm currently following a tutorial to use measures as a filter (video here). I'm running into a DAX issue when trying to use GENERATESERIES on a measure that I have. 

At around 2:25 in the video, the presenter uses a measuer as the max part of GENERATESERIES. I have done this with 2 other measures with a simple SUM measure, but this measure I'm currently trying requires a DIVIDE. This is throwing an error to GENERATESERIES. Here is my measure: 

Change % = 
DIVIDE(
    SUM('table1'[Numerator]),SUM('table1'[Denominator]),"-"
)

I'm formatting this as a percentage. 

When I use this in a table create I get this error: 

Obviously this is because I'm tryign to pass a percentage into GenerateSeries. I'm not sure how to fix this when I need the series to give a range of percentages. 

Any ideas with this? Appreciate the help!

[AlexisOlson · Accepted solution]

I don't think this has to do with percentage but rather the text data type you use for the third argument of DIVIDE, "-".

Try removing that or using 0 instead. You can format a zero as something else when you are displaying, but you don't want strings inside your math like that.

[Anonymous]

@AlexisOlson Great catch! I can't believe I missed that haha. 

I had to also play around with the incremental value to get it to work since its basing the value as a decimal. 
My code looks like this: 

Change % Number Filter = 
GENERATESERIES(0, [% Calc],0.0001)

Thank you! Accepting as solution!