Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have Two tables
One's name v_PBI_CEScoreCard_CERegion and colums are;
RepPointName, SalesRepName, PersonalCost
The other one is Dim_RepPoint and its colums are
RepPointName, RepPointCost
I create a relationship between these two tables using by RepPointName Column.
I want to create a mesure for a maxrix visuals Row SubTotals . And I create 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 right calculation at the row subtotals. but it also add RepPointCost for every SalesRep by row . I just want to see RepPointCost into to subtotal . Can you helpme about it?
Here is example about it
Total are correct but rows are not.
Best Regards
Sinan
@sinanalmac, Try a change like
TotalCost With RepPoint = SUM(v_PBI_CEScoreCard_CERegion[PersonalCost]) + SUMX(v_PBI_CEScoreCard_CERegion[RepPointName], Maxx(Dim_RepPoint[RepPointCost], Dim_RepPoint[RepPointName], v_PBI_CEScoreCard_CERegion[RepPointName]))
Hello ,
Thank you @amitchandak .
Your code was made an erorr. I Couldn't provide the second argument
I inspired your code and wrote this but it also wasn't worked 😞
TotalCost With RepPoint = SUM(v_PBI_CEScoreCard_CERegion[PersonalCost]) +
CALCULATE(MAX(Dim_RepPoint[RepPointCost]),
FILTER(Dim_RepPoint,
Dim_RepPoint[RepPointName] IN VALUES(v_PBI_CEScoreCard_CERegion[RepPointName])
)
)
regards
Sinan
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |