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.
Hi there,
I have the following dataset...
Sample APR is a calculated column which contains randomly generated numbers.
APR Group groups these. So basically 5.X = 5, 6.X = 6, etc etc.
I want to create a third calculated columns which counts the number of distinct values in the Sample APR column, desired output like the following....
I naturally tried to use DISTINCTCOUNT, with the following DAX:
Test = CALCULATE(DISTINCTCOUNT(Table1[Sample APR]),ALL(Table1), Table1[APR Group] = EARLIER(Table1[APR Group]))
Thanks @tex628
That appears to be grouping the APR Group column rather than the Sample APR one though. Been trying variations of your solution but still no luck unfortunately.
My apologies, i didnt read the initial post well enough!
Column = CALCULATE(COUNTROWS(Table1) , ALL(Table1) , Table1[Sample APR] = EARLIER(Table1[Sample APR]) , Table1[APR Group] = EARLIER(Table1[APR Group]))
Hope it works!
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 |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |