Forum Discussion
Helper IIITop 10 on values
Hello,
I have to make a hierarchical table of the top 10 customers by the amount of im margin.
I know how to limit the quantity, the problem is that it does not limit it for all organizations, how could I limit the margin to the top 10 quantities.
I am adding an example in the attachment
The wish is to get like this
example:
https://drive.google.com/file/d/1E1pdjB1xKWsCqKTjEE2J3YUH_mAUyyJF/view?usp=sharing
thx
5 Replies
You should be able to use the filter tab and unselecte the 'empty' values for the measure 'Top 10 kupcev'
- LeaRupnik
Thanks,
this works, but I'm having trouble sorting.
I have a measure now
Količina =
var _max = MAXX(ALLSELECTED('nov_27'), nov_27[datum_posnetka])
return
CALCULATE (
SUM (nov_27[izdkol] ),
FILTER ( ALL ( nov_27), nov_27[datum_posnetka] = _max),
VALUES(nov_27[kupec]), VALUES(nov_27[progenot]))
and the measure of sorting
Top 10 po kolicini = RANKX(ALL(nov_27[kupec]), [Količina],,DESC)
the table I show can be sorted both under LU_PCP and LU_FT, and within that then the quantities are fitted. I can't show the Top 10 columnsnew version powerBI
https://drive.google.com/file/d/1IZGEzxdqw84VZ4dCymFQdE_oi0XX-otv/view?usp=sharingthx
