Forum Discussion

rjunai200's avatar
rjunai200
Icon for Helper I rankHelper I
10 years ago
Solved

question about calcuated percentage

    i am having a problem when i display persentages visually with filters.   the way i have the data set up is                                                             Calculated feild (reve...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    rjunai200 try this...

     

    Measure = DIVIDE ( SUM('Table'[Revenue]), SUM('Table'[Budget]), 0 )

     

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

rjunai200 try this...

 

Measure = DIVIDE ( SUM('Table'[Revenue]), SUM('Table'[Budget]), 0 )

 

  • rjunai200's avatar
    rjunai200
    Icon for Helper I rankHelper I
    10 years ago

    hi it may have worked how would i convert a mesure into a percentage?? also can i do conditional formating on this to highlight numbers lets say greater than 100 and ect

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      10 years ago

      rjunai200 select the measure and...

      • rjunai200's avatar
        rjunai200
        Icon for Helper I rankHelper I
        10 years ago

        thank you that worked!

         

        would you happen to know any way i can conditional format the numbers?