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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Are you adding this formula as a column? It should be a measure I think.

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi melodypoh,

 

Yes as Anonymous explained, it should be a measure, not a column.

Do you want it to be in column?

 

Ninter