I'm going to add a cost/unit metric to my dashboard. The issue is that if I pick more than one month, the monthly computations are simply added together. As an example,
| Store |
Month |
Units |
Cost |
Cost/Unit |
| Blue |
Jan |
10 |
20 |
2 |
| Blue |
Feb |
20 |
60 |
3 |
| Red |
Jan |
10 |
30 |
3 |
| Red |
Feb |
20 |
80 |
4 |
When I create a table with with these, and select January and February in the Splicer it shows something like this:
| Store |
Cost/Unit |
| Blue |
5 |
| Red |
7 |
Of course this isn't the real total cost/unit for both months. Instead I'd like for it to show:
| Store |
Cost/Unit |
| Blue |
2.67 |
| Red |
3.67 |
I'm new to PowerBI, so I apologise for the lack of words to express this, but any assistance would be greatly appreciated!