PowerBI Total Cost Unit sums monthly calculations rather than creating a total for selected months

0 votes

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!

Apr 28, 2022 in Power BI by Neha
• 9,020 points

edited Mar 4 24 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP