Forum Discussion

64653463456greg's avatar
64653463456greg
Frequent Visitor
4 years ago

Percentage per serial number.

I have a bar chart that looks like the attached picture (picture #1). I have a bunch of serialnumbers that each appear the corresponding number of times in my data set (picture #3). Each row in the...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi 64653463456greg,

Assuming that your column header is of type number, try this:

Percent of Column Header =
IF (
    NOT ( HASONEVALUE ( 'DataTable'[Serial #] ) ),
    DIVIDE ( SUM ( 'DataTable'[Values] ), SELECTEDVALUE ( 'DataTable'[Header Column] ) ),
    SUM ( 'DataTable'[Values] )
)
64653463456greg's avatar
64653463456greg
Frequent Visitor
4 years ago

Hi danextian 

I dont get a value at all when I try your solution.

My Serial Numbers are in text format since they also contain letters.

Like I said before, I don't think what I want to happen is really posible.

Thank you for your reply though. 😄

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    4 years ago

    You will need to create a separate column in Power Query that will extract the numbers only or in the Percent measure, add a condition that will return NA or something else if the serial number cannot be converted to a number.

    • 64653463456greg's avatar
      64653463456greg
      Frequent Visitor
      4 years ago

      I don’t think you really understand what I want to get at. I might not be very clear in that regard.

      The value I want to extract is a percentage value of a total, where the total 100% is the same value. All dependent on a slicer that slices based on time.

       

      Basicaly this.

      Lets say the total is 10000. My value based on the slicer is 8000. I want that to show 80%.

      But now I just get 100% since thats the total of the sliced value, not the over all total.

      I don't really know how to describe it better.

       

       

       

       

       

       

       

       

       

       

      I don’t think what I want is possible. But correct me if I’m wrong. I’ve tried to find a way for the last month.

       

      So, the way your describing of extracting the number doesn’t work since the number need to change.