Forum Discussion

Lokisame's avatar
Lokisame
Helper I
7 years ago
Solved

Grouping data

Hello,    I need to sum grouping data. For example:  - I have two months  - 1st we have 9 000 sales and 10 000 target - 2nd we have 3 000 sales and 6 000 target   wehn I count progression for ...
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Lokisame,

     

    Please try this measure:

    percent =
SUMX (
    VALUES ( TB1[Month] ),
    CALCULATE ( SUM ( TB1[Sales] ) ) / CALCULATE ( SUM ( TB1[traget] ) )
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Lokisame,

 

Please try this measure:

percent =
SUMX (
    VALUES ( TB1[Month] ),
    CALCULATE ( SUM ( TB1[Sales] ) ) / CALCULATE ( SUM ( TB1[traget] ) )
)

 

Best regards,

Yuliana Gu

  • Lokisame's avatar
    Lokisame
    Helper I
    7 years ago

    Thank you very much :) It is very simple and useful.