showing summarised value which can be dynamic

[ajin]

Hi guys, new in pbi, hence needed your help. How do i show a column sum throughout all rows such as the value in static r. Currently i hard coded it as a static value ( static r = 352493410) but as the  data refresh's i want to show it change dynamically (since the total can change) while remaining as a static total through out the  rows in the column.

[Stachu]

you need to replace red syntax with whatever is relevant for you

Static r = CALCULATE(SUM(TableName[ColumnName]),ALLSELECTED(TableName))

[ajin]

Static r = CALCULATE(SUM(TableName[ColumnName]),ALLSELECTED(TableName))



this works but in my case i am using a measure (80% of revenue) hence any alternative ? 

[Stachu · Accepted solution]

then it's even simpler

Static r = CALCULATE([80% of revenue],ALLSELECTED(TableName))

[ajin]

It worked. Thanks 🙂