Forum Discussion

FSK's avatar
FSK
New Member
3 years ago

Create calculation between 2 lines in a TABLE report

Hello, 

 

I need to make a calculation between 2 lines of a PBI TABLE.

see below, I would need to calculate the % of evolution between the line FM and Compass.

I would like to create a measure, but I do not know how to proceed.

Thanks for help

 

 

 

 

Need Help

2 Replies

  • ToddChitt's avatar
    ToddChitt
    Icon for Super User rankSuper User
    3 years ago

    You should create two intermediate measures first:

    My Compass Measure = CALCULATE ( SUM ([some value]), [Source] = "Compass")

    Do the same for FM

     

    Now create the measure that compares them:

    My Comparison Measure = DIVIDE ( [My Compass Measure], [My FM Measure], 0 )

     

  • FSK's avatar
    FSK
    New Member
    3 years ago

    Hello ToddChitt,

    how to proceed to put it in line?

    I need to calculate for each quarter the evolution, and put it in a 4th line.

    thanks