Forum Discussion
cumulative frequency chart
I have a single data column - "number of seconds" - from which I want to plot preferably a cumulative frequency or, if not, a normal distribution curve.
My data has approx. 4000 rows and its range is (in whole numbers) anywhere from 0 to around 2.5m.
I have no idea even whether this is possible in Power BI. Is it?
Hi AndrewPF,
If you have a single column of values then let's by sorting them in ascending order. Follow these steps to get Cumulative Frequency.
Use below DAX formula to get the frequency of every individual value.
Table 2 = SUMMARIZE('Table','Table'[Values],"Frequency",COUNT('Table'[Values]))Create a rank column based on sort order.
Rank = RANKX('Table 2','Table 2'[Values],,ASC)Use this formula to get CF.
Cumulative Frequency = SUMX('Table 2',IF('Table 2'[Rank]<=EARLIER('Table 2'[Rank]),'Table 2'[Frequency]))Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
1 Reply
Hi AndrewPF,
If you have a single column of values then let's by sorting them in ascending order. Follow these steps to get Cumulative Frequency.
Use below DAX formula to get the frequency of every individual value.
Table 2 = SUMMARIZE('Table','Table'[Values],"Frequency",COUNT('Table'[Values]))Create a rank column based on sort order.
Rank = RANKX('Table 2','Table 2'[Values],,ASC)Use this formula to get CF.
Cumulative Frequency = SUMX('Table 2',IF('Table 2'[Rank]<=EARLIER('Table 2'[Rank]),'Table 2'[Frequency]))Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI