Forum Discussion
How to Construct a Relative Frequency Distribution (percentage distribution) on Power BI?
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:
- Total Work Order = SUM(MasterWO[Work Order])
The Sum of all work orders
- Average Time for Fulfillment (hrs) = AVERAGEX(MasterWO,MasterWO[TimeForFulfillment (Hrs)])
The Average time for fulfillment the works orders
- 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:
3 Replies
The measures should work. It seems that you've answered the question by yourself, is there any problem?
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.
