Forum Discussion

bilingual's avatar
bilingual
Icon for Helper V rankHelper V
3 years ago

Aggregate Data in a total

Hi, i have a Data sheet, which is similar to : I would like to create Type which is "TOTAL"  - all Data numbers aggregated so for example i can compare Type 1 with the "TOTAL", which is the best way...
Need Help
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

Hello bilingual ,

 

You could create a new measure that looks like this

 

Total  = Sum( Tablename[Numbers] )

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

  • bilingual's avatar
    bilingual
    Icon for Helper V rankHelper V
    3 years ago

    Thanks, will it be dynamic according year and month and not just create a total with no regards to date?

    • Idrissshatila's avatar
      Idrissshatila
      Icon for Super User rankSuper User
      3 years ago

      Hello bilingual ,

       

      yes true, if you click any year or month the data will change according to the selected.

       

      If I answered your question, please mark my post as solution, Appreciate your Kudos  👍

      Follow me on Linkedin

      • bilingual's avatar
        bilingual
        Icon for Helper V rankHelper V
        3 years ago

        Im sorry but the challenge is that i use a filter for the report so only one Type figures, for example Type 2.

        But i  still need to compare it to the Total sum.

        I think i need to use condittional Total with some formula like CALCULATE, ALL etc.