I want to create a measure that doesn't affect by row level. only add the value to subtotal.

[sinanalmac]

Hi All ,

I have two tables

One's name v_PBI_CEScoreCard_CERegion and the columns are;

RepPointName, SalesRepName, PersonalCost

The other one is Dim_RepPoint and its columns are
RepPointName, RepPointCost

I created a relationship between these two tables using by RepPointName Column.

I want to create a measure for a matrix visuals Row SubTotals. And I created this:

TotalCost With RepPoint = SUM(v_PBI_CEScoreCard_CERegion[PersonalCost]) + SUMX(VALUES(v_PBI_CEScoreCard_CERegion[RepPointName]), LOOKUPVALUE(Dim_RepPoint[RepPointCost], Dim_RepPoint[RepPointName], v_PBI_CEScoreCard_CERegion[RepPointName]))

This one is showed the right calculation for the row subtotals. but it also adds RepPointCost for every SalesRep by row. I just want to see RepPointCost into the subtotal.  my formüla  olsa add  the value to salesRepname .  Can you help me with it?

 here is my  visual  explanation

Here  my file that I worked for

https://www.dropbox.com/s/qd34mtwku8xvvcj/Solutio.pbix?dl=0 

 Best regards
Sinan 

[amitchandak]

@sinanalmac , For subtotal

we usually do like

calculate([Your measure], removefilters(Table[Sales Rep]))

Grand total

calculate([Your measure],allselected( ))

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s