Forum Discussion

KubenM's avatar
KubenM
Icon for Advocate II rankAdvocate II
3 years ago
Solved

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

Hello How to I show a Project Size; Project Count per Size, 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 val...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi KubenM ,

 

Like this?

Just create a measure to count rows and a column to calculate total value, as the following shows:

countrows = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[item]=SELECTEDVALUE('Table'[item])))
Total = 'Table'[value]*[countrows]

You can also refer to my pbix file for better understanding.

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • KubenM's avatar
    KubenM
    Icon for Advocate II rankAdvocate II
    3 years ago

    Thank you for your time and effort in this regard Selina.