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

Interkoubess's avatar
Interkoubess
Icon for Solution Sage rankSolution 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
      Icon for Solution Sage rankSolution 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
        Icon for Solution Sage rankSolution 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