Forum Discussion
Matrix exporting question
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
dmoney7612 Hard to say really. You look like you are using an existing measure for the ranking, what is the formula for that measure?
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)-1dmoney7612 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-TITHW/m-p/434008Greg_Deckler Correct, all are measures. Simple stuff using a combination of CALCULATE and SUM
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