Forum Discussion
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, b...
ToddChitt
Super User
Super UserYou 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 )