Reading your book "PowerPivot for the Data Analyst" I found myself stuck on the following thing.
On page 211, your explanin how to obtain unique values by using a mesuare.
= COUNTROWS(DISTINT(Sales[Customer]))
I wonder how to use a measure on this example to calculate the Median (and as extension the Lower Quartile and Upper Quartile).
I have been through all the functions however I do not seem to find a way of doing it.
Cheers
On page 211, your explanin how to obtain unique values by using a mesuare.
= COUNTROWS(DISTINT(Sales[Customer]))
I wonder how to use a measure on this example to calculate the Median (and as extension the Lower Quartile and Upper Quartile).
I have been through all the functions however I do not seem to find a way of doing it.
Cheers
