cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aj1973
Resident Rockstar
Resident Rockstar

Power BI desktop' s November version

Hi all,

 

I have been reporting issues with my latest Power BI Version: 2.87.1061.0 64-bit (November 2020). It just stops in the middle of my work and a Popup window prompts me to report the issue without giving me the chance to save my latest changes! it happened to me 6 times with this version but never before.

Also another weird thing yesterday with a DAX formula SUMX = SUMX('TABLE_X', TABLE_X[A] / TABLE_X[B])  returns a completely false result so I had to use SUM = SUM(TABLE_X[A]) / SUM(TABLE_X[B])

 

Any idea?

 

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!
1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @aj1973 ,

 

Have you upgrade the Power BI Desktop to December Version? Does the issue still exist? I checked the Issue forum but didn't find any records about such issue. I was thinking if it was a "Not Enough Memery" error. Anyway, is there detail error message showed in the popup window?

 

Best Regards,

Jay

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

View solution in original post

6 REPLIES 6
v-jayw-msft
Community Support
Community Support

Hi @aj1973 ,

 

Have you upgrade the Power BI Desktop to December Version? Does the issue still exist? I checked the Issue forum but didn't find any records about such issue. I was thinking if it was a "Not Enough Memery" error. Anyway, is there detail error message showed in the popup window?

 

Best Regards,

Jay

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

View solution in original post

Hi @v-jayw-msft 

So far so good with December version. 

As I said, been using Power BI desktop for more than 2 years and never happened before through all versions.

Thanks

 

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!
amitchandak
Super User IV
Super User IV

@aj1973 , Try formula like

SUMX = SUMX('TABLE_X', divide(TABLE_X[A] , TABLE_X[B]))

 

We have not seen any issue like this in Nov 2020.  You check issue like https://community.powerbi.com/t5/Issues/idb-p/Issues



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi @amitchandak 

 

I sure did that too. still same result. by the way when i use * to multiply the result is fine.

Thank you for your reply

 

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!

@aj1973 , check the data type of 2. Make sure both are of the number data type.  And try with divide function



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Both columns are exact same type the $, no empty fields, no null fields, same exact columns.

 

Anyway, this isn't my main issue, the main problem is the Poup window in the middle of my work that forces me to shuts down my desktop and lose my latest changes. I was wondering if any one else had the same issue with this latest version of power bi.

 

Thank you again @amitchandak for your time.

 

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.