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.

     

samuelhoward's avatar
samuelhoward
Frequent Visitor
1 year ago

Update: I figured out  I need to use the Matrix table, and NOT "table". When I put inthe three DAX measures you stated, my percentage is not working as they are all listed out as 100.00. Any thoughts? Can you check the code I am using, as I think the issue might be in there:

1. Frequency Measure: 

  • Frequency = COUNTROWS(FILTER('Corrected', 'Corrected'[In total, how many times did you serve/act in this capacity?] = MAX('Corrected'[In total, how many times did you serve/act in this capacity?])))

    Note: column name in my data is called "In total, how many times did you serve/act in this capacity?", as such, I updated "Occurence" from your code to work with mine.

2. Total Count Measure:

  • Total Occurrences = COUNTROWS('Corrected')

3. Percenage Measure:

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