Forum Discussion

mariner84's avatar
mariner84
Icon for Advocate I rankAdvocate I
6 years ago
Solved

Percentage in clustered column

Hello,   I have a clustered column showing total requests by date, but I'd now also like to show what percentage of the requests came from a certain criteria.   I have a sample pbix here   ...
  • TomMartens's avatar
    6 years ago

    Hey mariner84 ,

     

    I created a measure "Assignment Business Partner" using this DAX:

     

    Assignment Business Partner = 
     DIVIDE(
         CALCULATE(
             COUNT('Page 1'[Number])
             , FILTER(ALL('Page 1'[Level 4]) , 'Page 1'[Level 4] = "Business Partner")
         )
         , CALCULATE(
             COUNT('Page 1'[Number])
             , ALL('Page 1'[Level 4])
         )
     ) 

     

    adding this measure to the clustered line chart, to the line values

    will result in this chart:

    To achieve the formatting as a percentage value, you can either multiply by 100 by tweaking the measure, or you can use the formatting of the measure.

    Hopefully, this is what you're are looking for.

     

    Regards,

    Tom