dax for guage

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))

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.