Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with DAX - Percent Query

Hi All,   Does anyone know a DAX where I can work out the percentage of jobs complete please?   =(Total Jobs - Open Jobs ) / Total Jobs *100    - Is what i use in excel. I cant seem to figure thi...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Assume you have two measures [Open Jobs], [Total Jobs]

    Divide([Open Jobs], [Total Jobs])

     

    Mark this a % column

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks both. Neither of these seems to be giving me the correct information.