cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
prash4030 Frequent Visitor
Frequent Visitor

Dax PowerPivot Adding Measure

Hi, need help with creating measure

 

 i'm trying to create a measure in powerpivot to add total of a measure to another measure. For example, in below table

 i want to add total of Internal measure (with is 20 in this case) to Owned only for RSD.

 

 OwnedInternal
IT2010
WPS2010
RSD10 

so, my new measure should look as per below table. (Final measure).

 

 OwnedInternalFinal
IT201020
WPS201020
RSD10 30
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Dax PowerPivot Adding Measure

Hi prash4030,

 

Measure is already an aggregation value so I'm afraid you can't aggregation measure again. As a workaround, you may convert measure [Internal] to calculate columns, than create a calculate columns using DAX formula below:

 

Final = 
VAR total = SUM('Table'[Internal])
VAR Own_RSD = CALCULATE(SUM('Table'[Owned]), FILTER(ALL('Table'), 'Table'[Category] = "RSD"))
RETURN
IF('Table'[Category] = "RSD", total + Own_RSD, total)

Capture.PNG  

 

You may also refer to the sample pbix file.

 

Regards,

Jimmy Tao

3 REPLIES 3
Super User
Super User

Re: Dax PowerPivot Adding Measure

Hi @prash4030

 

I would need to see the code for your measures [Owned] and [Internal] but if I make a guess on what they look like, let's try this:

 

Final =
CALCULATE ( [Internal], All[Table1] )
    + CALCULATE ( [Owned], KEEPFILTERS ( Table1[FirstField] = "RSD" ) )

 

where Table1 is the name of the table with your data and FirstField is the name of the column containing "RSD", "IT", etc.

 

Always show the structure of your tables with names so it is easier for people to help.

Community Support Team
Community Support Team

Re: Dax PowerPivot Adding Measure

Hi prash4030,

 

Measure is already an aggregation value so I'm afraid you can't aggregation measure again. As a workaround, you may convert measure [Internal] to calculate columns, than create a calculate columns using DAX formula below:

 

Final = 
VAR total = SUM('Table'[Internal])
VAR Own_RSD = CALCULATE(SUM('Table'[Owned]), FILTER(ALL('Table'), 'Table'[Category] = "RSD"))
RETURN
IF('Table'[Category] = "RSD", total + Own_RSD, total)

Capture.PNG  

 

You may also refer to the sample pbix file.

 

Regards,

Jimmy Tao

prash4030 Frequent Visitor
Frequent Visitor

Re: Dax PowerPivot Adding Measure

thank you so much. it worked. thank you

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 340 members 3,473 guests
Please welcome our newest community members: