How do I perform a sum of values for a unique field name within a field?

[scheibercamo]

For example:

Income	Managed Section 05
500	Cats
600	Cats
784	Dogs
839	Cats
541	Dogs

I want to know the SUM income of all field names "Cats" under "Managed Section 05"

[scheibercamo]

How do I keep the number for this expression a static KPI within my dashboard?

[OmarBenSalem]

count(distinct {<[Managed Section 05]={'Cats'}>}  ID) depends on your selections.

if want to have the count distinct id for all cats independant of your selections, you only have to add 1 :

count(distinct   {1<[Managed Section 05]={'Cats'}>}  ID)

[sumitjadhav]

Try this also,

Tab1:

LOAD Income,

     [Managed Section 05]

FROM

(ooxml, embedded labels, table is Sheet1);

load *,

if(WildMatch([Managed Section 05],'Cats'),[Managed Section 05]) as new

Resident Tab1;

DROP Table Tab1;

Output:

without using set analysis.