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 d...
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.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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.