Repeat result sum on all rows

[freginier]

Hi all, 

I have this kind of table :

Category	Project	Amount
CAT1	Project1	10
CAT1	Project2	20
CAT2	Project3	30
CAT3	Project4	40
CAT3	Project5	50

I want to summurize CAT3 and repeat the value for all rows but I want don't display CAT3. 

Result expected :

Category	Project	Amount	CAT3
CAT1	Project1	10	90
CAT1	Project2	20	90
CAT2	Project3	30	90

How can I do this with DAX ? 

Thank you ! 

[Samarth_18]

Hi @freginier ,

Create a measure as below :-

Measure =
CALCULATE (
    SUM ( 'Table'[Amount] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Category] = "CAT3" )
)

and now add filter as below on your visual:-

[PaulDBrown · Accepted solution]

Use this measure:

CAT3 value = CALCULATE (SUM(Table[Amount]), Table[Category] = "CAT3")