MdxScript(Model) (4, 21) Error - Couldn't load data for this visual from IPMT in Measure

[mrothschild]

PBIX file is here: https://drive.google.com/open?id=1L0ocvMPMCNtYLA3nX3ZvxgZB6HaMW-eg

The error message I'm getting is as follows:

The Measure formula that's throwing the error is:

ipmt = IPMT(0.08/12,MAX('Fact'[Period]),120,200000,0,0)

I was trying to follow this YouTube step for step: https://youtu.be/hZBQKUbLofE?t=586

and unless my eyes are wrong, believe I've recreated the Measure formula exactly.

Expected result is a table that doesn't throw an "Can't display the visual" error and to recreate the end result in the YouTube video linked above.

Thanks!

[lbendlin · Accepted solution]

the second argument cannot be bigger than the third.