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

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