How to I show a Project Size; Project Count, and Total Story Points per Project Size on one Power Bi Visual

Kuben Moodliar 21 Reputation points
2022-11-30T12:08:09.667+00:00

Hello
How to I show a Project Size; Project Count, and Total Story Points per Project Size on one Power Bi Visual?

Example:
I have 3 Project sizes i.e. Small, Medium, and large. These values are visible in one column in my data set.
I created a Lookup table to define the number of Story Points that each project size would equate to.
Project Story Points Definition:
Small = 50
Medium = 100
Large = 150

If I have 2 small projects; 1 medium project, and 3 large projects to complete in Year 2022, how do I show the number of projects per size and the total Story per size. ie. 2 x Small = 100; 1 x Medium = 100; 3 x Large = 450 on one Power Bi visual in year 2022.
In year 2023 I will need to show the same and so on.

I would really appreciate your assistance in this regard. My DAX knowledge in near to non-existent.
Thank you
Kuben

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,674 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dillon Silzer 56,361 Reputation points
    2022-11-30T14:32:17.307+00:00

    Hi @kubenmoodlia

    Unfortunately Power BI is not supported on this forum at this time. It is best that you reach out to PowerBI experts at https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services and they will gladly assist with more expertise.

    ----------------------------------------------

    If this is helpful please accept answer.

    0 comments No comments

0 additional answers

Sort by: Most helpful