Forum Discussion
freginier
Solution Sage
Solution SageRepeat result sum on all rows
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 !
Use this measure:
CAT3 value = CALCULATE (SUM(Table[Amount]), Table[Category] = "CAT3")
2 Replies
PaulDBrownCommunity Champion
Use this measure:
CAT3 value = CALCULATE (SUM(Table[Amount]), Table[Category] = "CAT3")
Samarth_18Hi 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:-