cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Guils New Member
New Member

3 SAME calculations, 3 DIFFERENT results / mixing measures, variables and calculated table

Hello PowerBI Desktop community,

I am trying to calculate a DSO KPI by exhaustion method without using a massive CROSSJOIN... (and avoid having a 20 millions rows table...)

Among all the steps I have, I am having trouble at a specific one. I have the feeling I am using the same calculation but actually I am having 3 different results... : 

  • var_1 => variable calculated from a SUMMARIZE
  • var_2 => variable calculated from a simple CALCULATE
  • var_3 => measure calculated from a CALCULATEDTABLE and SUMMMARIZE

My expected and the right result is var_2Unfortunately to go furher into the calculation I would like to have var_1 or var_3.

Please find the .pbix here:

https://wetransfer.com/downloads/9ab8d678da594ec26a403ad6ce7758eb20190607214623/0ed5d9

Hope it will be enough to explain my issue. If  not, don't hesitate to ask for more questions....

Thank you in advance for all your help.

Guillaume

1 REPLY 1
Stachu Super Contributor
Super Contributor

Re: 3 SAME calculations, 3 DIFFERENT results / mixing measures, variables and calculated table

there are actually quite different calculations, so the differences are expected

the model seems a bit chaotic what exactly do you want to achive here?

 

values in from REV summed in EUR, based on a exchange rate from TAUX? would having a Revenue column in EUR solve the problem? it may be easier to achive in the Query Editor, as you can do joins on multiple columns there

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

Proud to be a Datanaut!

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 351 members 3,209 guests
Please welcome our newest community members: