Forum Discussion

mrothschild's avatar
mrothschild
Continued Contributor
3 years ago
Solved

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

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!

1 Reply

  • the second argument cannot be bigger than the third.