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 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/434008

dmoney7612's avatar
dmoney7612
Helper II
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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