Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sumx with Dynamic Year

Hello,   I got a question. I want to make the following formula with a new column: % = Umsatz[Umsatz]/SUMX(FILTER(Umsatz;Umsatz[Bereich]="Ums"&&Umsatz[Jahr]=2017);Umsatz[Wert]) But instead of 201...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ok something is still wrong. In my table the SumMyPeriod, is now the sum of the Row but not the overall of the year. But just in my table. When I put it in a single card, it's the overall sum.

     

    Measure
    SumMyPeriod = SUMX(FILTER(Umsatz;Umsatz[Bereich]="Ums"&&Umsatz[Jahr]=[MyPeriod]);Umsatz[Wert])

    Measure
MyPeriod = SELECTEDVALUE(Umsatz[Jahr])

    Measure
    Percentage = DIVIDE(Umsatz[Umsatz];Umsatz[SumMyPeriod])

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      please provide sample file