Forum Discussion

silverbullet1's avatar
silverbullet1
Regular Visitor
7 years ago

Count of Distinct Values not working

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...
General Comment
Need Help
silverbullet1's avatar
silverbullet1
Regular Visitor
7 years ago

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.

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

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!