Forum Discussion

showard40k's avatar
showard40k
Regular Visitor
1 year ago
Solved

Unique number column

Unique number column   I have the following column of occurrences ranging from 1 to 5. What DAX do I need in my measure to capture the frequency of each number? I also want to report the total, and...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    These measures work

    Measure = COUNTROWS(Corrected)
    Measure 2 = CALCULATE([Measure],ALL(Corrected[Occurrence]))
    Measure 3 = DIVIDE([Measure],[Measure 2])

    Hope this helps.

     

dharmendars007's avatar
dharmendars007
Memorable Member
1 year ago

Hello showard40k 

 

To calculate the frequency and percentage of each occurrence in Power BI, based on your data from the "Corrected" table, you can create a few DAX measures like below

 

1. Frequency Measure

Frequency =
COUNTROWS(FILTER('Corrected', 'Corrected'[Occurrence] = MAX('Corrected'[Occurrence])))

 

2. Total Count Measure

Total Occurrences = COUNTROWS('Corrected')

 

3. Percenage Measure

Percentage = DIVIDE([Frequency], [Total Occurrences], 0) * 100

 

Create a Table Visual:

  1. Add the Occurrence column from the Corrected table.
  2. Use the three DAX measures (Frequency, Total Occurrences, and Percentage) in the visual.

 

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

 

Thank You

Dharmendar S

LinkedIN 

 

 

  • showard40k's avatar
    showard40k
    Regular Visitor
    1 year ago

    Hi Dharmendar, I completed the measures, but not sure how to put them into a table. When I do, I get the following, which does not look right. Note, in my data I have 10,000 rows, so its going to be different result than the example I gave above: