Forum Discussion

dmoney7612's avatar
dmoney7612
Helper II
5 years ago

Matrix exporting question

When I export the data from the below matrix to Excel, the rankings all appear as "1" in the file. Is there a way to work around this issue? I noticed this isn't a problem when exporting from the tab...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

dmoney7612 OK, well same version I am on. I have attached the PBIX below signature. You want the matrix visual in the lower left of the page. Measure 3 is the ranking measure.

  • dmoney7612's avatar
    dmoney7612
    Helper II
    5 years ago

    Greg_Deckler Ranks look fine when exported from your file. Only difference it seems is the Calculate(SUM portion of your ranking formula. You think that could be the issue? I have no clue otherwise 

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      5 years ago

      dmoney7612 Hard to say really. You look like you are using an existing measure for the ranking, what is the formula for that measure?

      • dmoney7612's avatar
        dmoney7612
        Helper II
        5 years ago

        Greg_Deckler  Probably doesn't help without having my file on hand but this is it:

         

        ADS % Growth = DIVIDE(([YTD ADS]/'Selling days'[FYTD Selling Days]),([PYTD ADS]/[PYTD Selling Days]),2)-1