Forum Discussion
Count IF / 'Set Analysis'
v-yalanwu-msft This works great Thank you,
Per chance are you able to guide me on replicating this in a graph.
So the vendor would act as the Legend, the month as the x axis and the Measure as the value BUT only for the the 100 percentages.
so plot Month 1, Vendor VO640 = 69.15% to be plotted on a graph.
I have tried to do this but cannot seem to get the right output.
Thanks in advance.
Hi，Anonymous ;
Why don't Vendor set Count of Column as Legend? If Vendor is set as Legend, logically it must be 100%, so you can try to set Count of Column as Legend.
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the input, however I believe my issue is that the "Count of the column " is already a generated field it is not part of the intial load.
Column = count(Sheet1[Correction On-time del])Whereas I see in your example it is loaded as a field.
My other issue that will come into it is that there will be multiple vendors within the data set, currently I am working with a smaller dataset in order to learn and practice.
script is below
= Table.TransformColumnTypes(#"Promoted Headers",{{"Vendor", type text}, {"Name 1", type text}, {"Purchasing Document", Int64.Type}, {"Material", type text}, {"Material description", type text}, {"Purchasing Group", type text}, {"Month", Int64.Type}, {"Material Doc. Year", Int64.Type}, {"Corr. Qty. Reliab.", Int64.Type}, {"Correction On-time del", Int64.Type}, {"Sched. date", type date}, {"GR date", type date}, {"Schedule line number", Int64.Type}, {"Post.qty.", Int64.Type}, {"Quantity Received", Int64.Type}, {"Scheduled Quantity", Int64.Type}, {"Days to late WE", Int64.Type}, {"Days to early WE", Int64.Type}, {"Delivery Note", Int64.Type}, {"Changed by", type text}, {"Changed On", type date}, {"Dat.reliab.", Int64.Type}})