Forum Discussion

PWRBI's avatar
PWRBI
Frequent Visitor
3 years ago
Solved

Summarize in DAX, HELP :)

I have the following data: Dimension1, Dimension2, Value1, and Value2. Now, I want each row to be calculated first in Power BI (PBI), and then the sum of all individual positions from Dimension2 sho...
SUMMARIZE
  • Nathaniel_C's avatar
    Nathaniel_C
    3 years ago

    Hi PWRBI ,
    If I understand your issue correctly, you might try this.

    Column = IF(Summary[Dim2]="Total",Sumx(Summary,Divide(Summary[Val1],Summary[Val2])),Divide(Summary[Val1],Summary[Val2]))


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel





Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
3 years ago

Hi PWRBI ,

How do you get 38,516.78 on the first row based on this formula.  If you wish me to look at this please include an explanation of what you are trying to do and make your example much clearer than what you did here.  Otherwise you may want to re post this.

Thank you,

 

Nathaniel

  • PWRBI's avatar
    PWRBI
    Frequent Visitor
    3 years ago

    Hi, how can I Upload a PBI File for you with an example?