Forum Discussion

igrandey89's avatar
igrandey89
Icon for Advocate II rankAdvocate II
4 years ago
Solved

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

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's avatar
    VahidDM
    4 years ago

    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/

     

     

2 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    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/