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 of them come out okay, mostly just NaNs. I know it works because it does in my Pivot table (pic 2). I tried both SUM and Average. Only average gave me a few correct answers.

 

Thank you in advance!

 

  • 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

11 Replies

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    Hi melodypoh,

     

    Did you try for example :

     

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

     

    Let us know.

     

    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