How to Construct a Relative Frequency Distribution (percentage distribution) on Power BI?

[joanperez]

How to Construct a Relative Frequency Distribution on Power BI?

Frequency of a class divided by total frequency of all classes is called relative frequency.  Relative frequency is expressed in term of percentage therefore it also known as percentage distribution.

Scenario:

Using Power BI, we want to design a Relative Frequency Distribution for the Time to Fulfillment for a "Work Orders" process.

“MasterWO” table

We need to create the following Measure on Power BI:

1. Total Work Order = SUM(MasterWO[Work Order])
   The Sum of all work orders

1. Average Time for Fulfillment (hrs) = AVERAGEX(MasterWO,MasterWO[TimeForFulfillment (Hrs)])
   The Average time for fulfillment the works orders 

1. Relative Frequency = (SUMX(MasterWO,MasterWO[Work Order])) / (CALCULATE(SUM(MasterWO[Work Order]),ALL(MasterWO[Time to Completed])))
   The Relative Frequency for work order arrange by the “Time to Completed”

Power BI Visualization:

[Eric_Zhang]

@joanperez

The measures should work. It seems that you've answered the question by yourself, is there any problem?

[joanperez]

Right ... The reason for the post is that I received many request for how to customize statistical process in Power BI. Here, I show a scenario of Relative Frequency Distribution.

[Eric_Zhang]

@joanperez

Great. Thanks for sharing.