Q/Q % Change (In scoring metric) - Help replacing -100%

[igrandey89]

Hi all,

I am currently stuck (maybe i've been looking at this too long, today) when building out a matrix for a scoring metric:

• Scores are based on the last 6 months and given to each individual customer
• I am trying to show the Q/Q timeline, for each customer, to show a trend in scores/improvement or decline in scoring.
  • Because it's based on the last 6 months, not all customers have "issues" for certain quarters--leaving them blank (see below)

This is causing my q/q % change's to be thrown off, displaying as -100% for any blank values:

Can anyone help with removing the -100% values, on the second table? I can't seem to figure it out. 

Much appreciated!!

[VahidDM · Accepted solution]

Hi @igrandey89 

As @AlexisOlson asked, please share the DAX code you have been using for Q/Q%.

BTW, you can use If statement like this:

IF([q/q %]=-100%,blank(),[q/q %])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[AlexisOlson]

What is the DAX you're using to populate the matrix?