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

Hello,

 

I'm sorry my previous post was incomplete, I've updated it now :)

You're Welcome SabineOussi and sorry for the delay

Sebastien