Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there.
Simple table below. If I filter on Person 'A', I want the SCORECARD to show 185. Otherwise, show the corresponding Total of the selected Person, i.e. 'B' = 20, 'C' = 30, and so on.
Many thanks in advance.
Solved! Go to Solution.
Hello,
this measure should do the work :
If you want your total to be corresponding to the new value shown in A, you can switch to this DAX with a SUMX :
Hi, @Power_It_Up
Your solution is great, @QuentinBl . It worked like a charm! Has your current issue been resolved?
Best Regards
Jianpeng Li
Hello,
this measure should do the work :
If you want your total to be corresponding to the new value shown in A, you can switch to this DAX with a SUMX :
User | Count |
---|---|
53 | |
35 | |
20 | |
15 | |
14 |
User | Count |
---|---|
94 | |
78 | |
37 | |
22 | |
18 |