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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
juhoneyighot
Helper III
Helper III

Overall total amount not showing

Hello,

 

I need help how to add the overall total of all Name (or Project). I have here a formula wherein it will only shows the total per Name (Project), per _Current PM Contact and per _Jobphase. I have a hard time what formula to insert here to get the overall total amount of all Name (Project).

 

Rev Recog =
VAR _project = [Est Rev] * [% Comp]
VAR _total =
SUMX ( ALLSELECTED ( msdyn_project[Name] ), [Est Rev] * [% Comp] )
VAR _total2 =
SUMX ( ALLSELECTED ( msdyn_project[Name] ), [Est Rev] * [% Comp] )
RETURN
IF (
ISINSCOPE ( msdyn_project[Name] ),
_project,
IF ( ISINSCOPE (msdyn_project[_CurrentPM contact] ),
_total,
IF ( ISINSCOPE (msdyn_project[_JobPhase] ),
_total2)

))

juhoneyighot_0-1721656340254.png

Hope you will help me on this.

 

Thank you so much.



1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @juhoneyighot - create a below measure to get the overall total amount of all projects (or names) in your calculation

 Measure:

Rev Recog =
VAR _project = [Est Rev] * [% Comp]
VAR _total =
SUMX (
ALLSELECTED ( msdyn_project[Name] ),
[Est Rev] * [% Comp]
)
VAR _total2 =
SUMX (
ALLSELECTED ( msdyn_project[Name] ),
[Est Rev] * [% Comp]
)
VAR _overallTotal =
SUMX (
ALL ( msdyn_project[Name] ),
[Est Rev] * [% Comp]
)
RETURN
IF (
ISINSCOPE ( msdyn_project[Name] ),
_project,
IF (
ISINSCOPE ( msdyn_project[_CurrentPM contact] ),
_total,
IF (
ISINSCOPE ( msdyn_project[_JobPhase] ),
_total2,
_overallTotal
)
)
)

 

Hope it works

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!





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

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Hi @juhoneyighot - create a below measure to get the overall total amount of all projects (or names) in your calculation

 Measure:

Rev Recog =
VAR _project = [Est Rev] * [% Comp]
VAR _total =
SUMX (
ALLSELECTED ( msdyn_project[Name] ),
[Est Rev] * [% Comp]
)
VAR _total2 =
SUMX (
ALLSELECTED ( msdyn_project[Name] ),
[Est Rev] * [% Comp]
)
VAR _overallTotal =
SUMX (
ALL ( msdyn_project[Name] ),
[Est Rev] * [% Comp]
)
RETURN
IF (
ISINSCOPE ( msdyn_project[Name] ),
_project,
IF (
ISINSCOPE ( msdyn_project[_CurrentPM contact] ),
_total,
IF (
ISINSCOPE ( msdyn_project[_JobPhase] ),
_total2,
_overallTotal
)
)
)

 

Hope it works

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!





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

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.