Forum Discussion
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...
Hi,
These measures work
Measure = COUNTROWS(Corrected)Measure 2 = CALCULATE([Measure],ALL(Corrected[Occurrence]))Measure 3 = DIVIDE([Measure],[Measure 2])Hope this helps.
Once I have the three measure created (Measure, Measure 2 and Measure 3) how do I create the table and place the measures in to look like yours?
Drag and drop