Forum Discussion
Ratio Calculation
Hi EbyEaso ,
Based on your problems, here are my answers.
First I created a table based on your description.
Then created four Measure.
Total Hardware Issues = SUMX(FILTER('Table', 'Table'[Type Of Issue] = "Hardware"), 1)Total Parts Issues = SUMX(FILTER('Table', 'Table'[Type Of Issue] = "Parts"), 1)Issue Ratio = DIVIDE([Total Hardware Issues], [Total Parts Issues])Ratio Display = (CONCATENATE("1:", [Issue Ratio]))Finally you will see the result you want.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank You ThxAlot and Jihwan_Kim
Bu am looking in a ration form. Example as below.
Thank You ThxAlot Jihwan_Kim
But am looking in a ration form.
Example as below.
| Site | Hardware | Parts | Ratio |
| Site 1 | 1 | 1:0 | |
| Site 2 | 2 | 1 | 1:1 |
| Site 3 | 5 | 15 | 1:3 |
Hi EbyEaso ,
Based on your problems, here are my answers.
First I created a table based on your description.
Then created four Measure.
Total Hardware Issues = SUMX(FILTER('Table', 'Table'[Type Of Issue] = "Hardware"), 1)Total Parts Issues = SUMX(FILTER('Table', 'Table'[Type Of Issue] = "Parts"), 1)Issue Ratio = DIVIDE([Total Hardware Issues], [Total Parts Issues])Ratio Display = (CONCATENATE("1:", [Issue Ratio]))Finally you will see the result you want.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thank you for the response and udpate. Apreciate it. It works. Cool.
I havew one more thing. What if we have more decimal values in the outout. I tried to chnage the decimal value to zero, but it wont change in the result.
Anonymous
Is it possible to remove the decimal points?