Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

View - Show Total by Category

Hi all.

I have a table with a filter, this table show me values and a graph

Everythig is fine except fot the graph

It is not showing the total month-to-month

Month on Axis, ACUMULADO and COMPROMETIDO for values, however ACUMULADO and COMPROMETIDO are a measures as I could solve this?

 

 

 

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    ACUMULADO = SUM(tb2[Value]) of all month and years

    COMPROMETIDO = SUM(tb1[Value]) of all month and years

     

    I do not know how to post the file here  =/

     

    Ty

  • Generally, load the file up on OneDrive or Box or Google, share it and paste the link to it.

  • Anonymous's avatar
    Anonymous
    8 years ago

    Sorry =/

     

    In my measure measure = calculate(sum(value); all(month))

     

    Remove All(Month) and It Worked

     

    Ty for the attention

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      ACUMULADO = SUM(tb2[Value]) of all month and years

      COMPROMETIDO = SUM(tb1[Value]) of all month and years

       

      I do not know how to post the file here  =/

       

      Ty

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion

        Generally, load the file up on OneDrive or Box or Google, share it and paste the link to it.