Earn 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 :