Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |