Forum Discussion
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...
Greg_Deckler Yes, desktop to CSV. I'm thinking it's an issue with the matrix format. Rankings appear fine when I export a table visual.
dmoney7612 Hmm, what version of the Desktop are you on? I can upload my test version if you think it might help.
Greg_Deckler Version: 2.93.641.0. Sure, send it on over.
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.
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