Forum Discussion

SabineOussi's avatar
SabineOussi
Skilled Sharer
10 years ago
Solved

Monthly Percentage

Hello,   Following this thread http://community.powerbi.com/t5/Desktop/Monthly-Comparison/m-p/22548 Now I want to add the percentage each value constitutes of the whole month.   I created a sim...
Need Help
  • LarsSchreiber's avatar
    LarsSchreiber
    10 years ago

    The difference is, that my [MonthlyValue] is e measure, and yours is the column name without aggregation. Put a SUM() around your "Table13[Monthly Value]" --> SUM( Table13[Monthly Value] ).

     

    The complete formula look like this:

     

    =SUM( Table13[Monthly Value] ) / 

    CALCULATE(

       SUM( Table13[Monthly Value] ),

       ALL(Tabelle13[Column1])

    )

     

    Does it work now? Is column1 the column with the customer?! Never use Columns without an aggregator (eg. SUM())!

     

    Regards,

    Lars

SabineOussi's avatar
SabineOussi
Skilled Sharer
10 years ago

This is what I tried and got.

 

Please advise if there was anything wrong.
I even tried sum and count after calculate but none was right.

LarsSchreiber's avatar
LarsSchreiber
Responsive Resident
10 years ago

The difference is, that my [MonthlyValue] is e measure, and yours is the column name without aggregation. Put a SUM() around your "Table13[Monthly Value]" --> SUM( Table13[Monthly Value] ).

 

The complete formula look like this:

 

=SUM( Table13[Monthly Value] ) / 

CALCULATE(

   SUM( Table13[Monthly Value] ),

   ALL(Tabelle13[Column1])

)

 

Does it work now? Is column1 the column with the customer?! Never use Columns without an aggregator (eg. SUM())!

 

Regards,

Lars

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hello SabineOussi

     

    The last LarsSchreiber formula is working pretty well !

     

    Here's the screenshot of what I did :

    The model :

     

    the formula 

     

    And the result :

     

    Sébastien