Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

dax for guage

hi

i am looking for to divide nd show the percentage of total requests created by printer requests where model id= PLI PRINTER & request type =support from all requested created

i.e 1035/315 

to display the calculation in a guage visual

Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a measure like

    divide(countrows(Table), calculate(countrows(Table), filter(Table, Table[model id]= "PLI PRINTER" && Table[request type] ="support")))

     

    or

     

    divide( calculate(countrows(Table), filter(Table, Table[model id]= "PLI PRINTER" && Table[request type] ="support")),countrows(Table))

  • Syndicate_Admin's avatar
    Syndicate_Admin
    5 years ago

    Don't @greeshma,

    Please send me some sample data, and I'll write you a detailed formula.

    Best regards

    Stephen Tao

    If this post helps, consider Accepting it as the solution to help other members find it faster.

34 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try a measure like

    divide(countrows(Table), calculate(countrows(Table), filter(Table, Table[model id]= "PLI PRINTER" && Table[request type] ="support")))

     

    or

     

    divide( calculate(countrows(Table), filter(Table, Table[model id]= "PLI PRINTER" && Table[request type] ="support")),countrows(Table))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Please send me some sample data, and I will write you a detailed formula.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Don't @greeshma,

    Please send me some sample data, and I'll write you a detailed formula.

    Best regards

    Stephen Tao

    If this post helps,then consider Accepting it as the solution to help other members find it faster.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Don't @greeshma,

    Please send me some sample data, and I'll write you a detailed formula.

    Best regards

    Stephen Tao

    If this post helps, consider Accepting it as the solution to help other members find it faster.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Don't @greeshma,

    Please send me some sample data, and I'll write you a detailed formula.

    Best regards

    Stephen Tao

    If this post helps, consider Accepting it as the solution to help other members find it faster.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Don't @greeshma,

    Please send me some sample data, and I'll write you a detailed formula.

    Best regards

    Stephen Tao

    If this post helps, consider Accepting it as the solution to help other members find it faster.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Don't @greeshma,

    Please send me some sample data, and I'll write you a detailed formula.

    Best regards

    Stephen Tao

    If this post helps, consider Accepting it as the solution to help other members find it faster.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Don't @greeshma,

    Please send me some sample data, and I'll write you a detailed formula.

    Best regards

    Stephen Tao

    If this post helps, consider Accepting it as the solution to help other members find it faster.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Don't @greeshma,

    Please send me some sample data, and I'll write you a detailed formula.

    Best regards

    Stephen Tao

    If this post helps, consider Accepting it as the solution to help other members find it faster.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Don't @greeshma,

    Please send me some sample data, and I'll write you a detailed formula.

    Best regards

    Stephen Tao

    If this post helps, consider Accepting it as the solution to help other members find it faster.