Forum Discussion
Need Calculations
Hi Everyone,
Need some help in creating measures/columns . Have Category ,Qty and count columns and based on Category selection filter it should show the ratio column . Ratio is (Count for each Category)/(Total qty for all the selected Categories ).
| Category | Qty | count | Ratio |
| A | 11 | 1 | 0.027027 |
| B | 11 | 1 | 0.027027 |
| C | 12 | 1 | 0.027027 |
| D | 3 | 2 | 0.054054 |
| Total | 37 |
If Category 'A' and 'B' is selected on slicer then it should show the output below:
| Category | Qty | count | Ratio |
| A | 11 | 1 | 0.045455 |
| B | 11 | 1 | 0.045455 |
| Total | 22 |
