Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dmoney7612
Helper II
Helper II

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 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!

 

dmoney7612_1-1621950232646.png

 

 dmoney7612_0-1621949889765.png

 

11 REPLIES 11
Greg_Deckler
Super User
Super User

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@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
 
 

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.