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 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 |
---|---|
54 | |
48 | |
19 | |
16 | |
15 |
User | Count |
---|---|
115 | |
42 | |
41 | |
27 | |
22 |