cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,199)