Forum Discussion

melodypoh's avatar
melodypoh
Frequent Visitor
8 years ago
Solved

Simple DAX calculation wrong

Hi, I just started using Power BI so I am slowly navigating as I go.    I am trying to recreate a report that I did in Excel but a simple calculation of (x-y)/x doesn't work in Power BI. A couple o...
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    Hi melodypoh,

     

    My former formula missed a parenthesis, sorry:

     

    BAND= Divide( Sum(Data[Q List])-Sum(Data[Q Band]),Sum(Data[Q List}),blank()).

    Try trhis Please

     

    Ninter

melodypoh's avatar
melodypoh
Frequent Visitor
8 years ago

It didn't... Please see the screenshot.

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi melodypoh,

 

What is the name of your table?

 

I wrote Data because I thought it was named Data, please replace Data by the real name.

 

Let us know...

 

Ninter

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    Hi melodypoh,

     

    My former formula missed a parenthesis, sorry:

     

    BAND= Divide( Sum(Data[Q List])-Sum(Data[Q Band]),Sum(Data[Q List}),blank()).

    Try trhis Please

     

    Ninter

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Sloppy typing. You're missing a close parentheses and you used a curly bracket instead of a square bracket.

     

    BAND = DIVIDE(
	SUM(Data[Q List]) - SUM(Data[Q Band]),
	SUM(Data[Q List]),
	BLANK()
)
    • Interkoubess's avatar
      Interkoubess
      Solution Sage
      8 years ago

      Yeah I was typing too quickly.

       

      Thank you Anonymous.

       

      melodypoh please try the corrected one and let us know.

       

      Ninter

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Interkoubessah yeah looks like you caught it at the same time I did. Cool.