Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Power BI Visualization:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |