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

Looks like they all produced the same answers. Wow, is this supposed to be this complicated? 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Looks like there is some relationship missing.  Share the link from where i can download your workbook.