Selecting a particular value in a filter to return the total of all values

[Power_It_Up]

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.

[Power_It_Up]

@QuentinBl Many thanks for this example. I shall try it soon. 👍

[Anonymous]

Hi, @Power_It_Up 

Your solution is great, @QuentinBl . It worked like a charm! Has your current issue been resolved?

Best Regards

Jianpeng Li

[QuentinBl · Accepted solution]

Hello, 
this measure should do the work :

Dax = IF(SELECTEDVALUE('Exemple 2'[Person]) = "A",CALCULATE(SUM('Exemple 2'[total]),ALL('Exemple 2'[Person])),SUM('Exemple 2'[total]))

It can be imporved with a 'switch' instead of a 'if' if you get other tests to do.

If you want your total to be corresponding to the new value shown in A, you can switch to this DAX with a SUMX :

Dax = SUMX('Exemple 2', IF('Exemple 2'[Person] = "A",CALCULATE(SUM('Exemple 2'[total]),ALL('Exemple 2')),'Exemple 2'[total]))