Forum Discussion
How do I show a Project Size; Project Count, and Total Story Points per Project Size on one Power Bi
- Anonymous3 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
- 3 years ago
Thank you for your time and effort in this regard Selina.
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
Thank you for your time and effort in this regard Selina.