Percentage of a certain serial number based on a slicer.

[64653463456greg]

 So, I have a bar chart that looks like this.

I have a bunch of serialnumbers that each appear the corresponding number of times in my data set.

With the slicer I can se how many times they appear during a certain time interwall.

What I’d like to do next is to create a similar bar chart but with percentages.

And I’d like the percentages to reflect not the overall total but the total of the row (serial number) of the bar chart.

So, let’s say the total of the top one is 18760.

If the total between 40 min and 100 min is 5455, I’d like to se that as a percentage of the 18760.

I’ve tried to resolve this but I’m getting nowhere.

Any help would be much appreciated.

Thank you.

[amitchandak]

@64653463456greg , Assume I have Count Sno

then - Total using values selected in slicer

calculate([Count Sno], allselected())

and - Ignoring - selected values

calculate([Count Sno], all())

[64653463456greg]

Please se attached picture.

This is what it looks like if I put it in a matrix. I KIND OF works, but not really.

What I would like to happen is this:

You have the serial numbers in the red square.

The total of cycles in the blue square.

And the total of cycles depending on time in the yellow square. The yellow square numbers change based on the value range in minutes in the time slicer.

What id like to get instead of the raw numbers are a percentage based on the total of the column (the numbers in the blue square.

So, in the one with serial number 205 and column total of 15019; there I’d like the 11671 number to instead be 77,71%.

Does this make sense?

This all would be best if it could be shown in a bar chart but if I must do it in a matrix, that work as well.

[64653463456greg]

Hi!

I cannot seem to get your suggestion to work.

Power BI is just getting me errors if I type your suggestion out.

Maybe I don't have the Serial number count in a way that works, I don't know.

Do you have any other suggestions or modifications I might?

Much appreciated