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
    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
    3 years ago

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

KubenM , You need somung like

 

concatenatex (values(table[Project]) , calculate([Count meausre] & " " & Max(table[Project]) & " " & [Other measure], " ; ")

 

 

You can use unichar(10)  for the new line. You can display it on card visual