Forum Discussion

ajin's avatar
ajin
Icon for Helper II rankHelper II
8 years ago
Solved

showing summarised value which can be dynamic

  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 a...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    then it's even simpler

    Static r = CALCULATE([80% of revenue],ALLSELECTED(TableName))
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

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

Static r = CALCULATE(SUM(TableName[ColumnName]),ALLSELECTED(TableName))
  • ajin's avatar
    ajin
    Icon for Helper II rankHelper II
    8 years ago
    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's avatar
      Stachu
      Icon for Community Champion rankCommunity Champion
      8 years ago

      then it's even simpler

      Static r = CALCULATE([80% of revenue],ALLSELECTED(TableName))
      • ajin's avatar
        ajin
        Icon for Helper II rankHelper II
        8 years ago

        It worked. Thanks :)