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

Thank you for the follow up LarsSchreiber!
It still did not work as a column even when adding SUM() but it worked as a measure. These two types still get me very confused.

Merci Anonymous

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi SabineOussi,

 

   the difference between calculated columns and measures is :

 

  • A Calculated Column runs the calculation on each individual row.  The calculation happens BEFORE aggregating.
  • A Calculated Measure runs the calculation on a collection of rows.  Calculations happen AFTER aggregating.

 

If you need more information this is the source.