Matrix exporting question

[dmoney7612]

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 table visual, but it doesn't seem to like the row drill down format I'm using with the matrix. Here is my ranking formula for reference...thanks in advance!

 

[Greg_Deckler]

@dmoney7612 How are you exporting, from the Desktop export to CSV file or in the Service? I tried replicating this but was not able to do so in the Desktop.

[dmoney7612]

@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. 

[Greg_Deckler]

@dmoney7612 Hmm, what version of the Desktop are you on? I can upload my test version if you think it might help.

[dmoney7612]

@Greg_Deckler Version: 2.93.641.0. Sure, send it on over.

[Greg_Deckler]

@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]

@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]

@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]

@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

[Greg_Deckler]

@dmoney7612 I'll see if I can mock something up with a similar formula. I take it all of those things are measures in that ADS % Growth measure formula? Are they all simple aggregation measures like SUM or are there some time intelligency things going on with them since I see the YTD stuff. Are you using Time Intelligence functions like TOTALYTD? Or are you doing the TI "the hard way". I just wonder if this is yet another instance where TI functions fail miserably. 

You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[dmoney7612]

@Greg_Deckler Correct, all are measures. Simple stuff using a combination of CALCULATE and SUM

[Anonymous]

Hi @dmoney7612 ,

Could you please provide your simplified pbix file(exclude sensitive data) in order to make troubleshooting? In this way, it may be easier for us to find the cause and get a solution.

Best Regards