Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to get Competitor ROI ?

Hi All

I have below table work fine :-

Now i need to Compute the ROI = COMP_NP/COMP_REV

COMP_ROI = DIVIDE ( SUM ( 'COMP'[COMP_REV] ), SUM ( 'COMP'[COMP_REV] ) )
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You can create a measure as -

    DIVIDE(COMP[COMP_NP],COMP[COMP_REV])

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    You can create a measure as -

    DIVIDE(COMP[COMP_NP],COMP[COMP_REV])