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] ) )   https://www.dropbox...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You can create a measure as -

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