Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 columns
new version powerBI
https://drive.google.com/file/d/1IZGEzxdqw84VZ4dCymFQdE_oi0XX-otv/view?usp=sharing
thx
i don't want without a top 10 column
@LeaRupnik try this:
Only write this measure:
Količina =
VAR _max = MAXX(ALLSELECTED('nov_27'), nov_27[datum_posnetka])
VAR _result =
CALCULATE (
SUM (nov_27[izdkol] ),
nov_27[datum_posnetka] = _max
)
VAR _rank =
RANKX(
ALLSELECTED(nov_27[kupec]),
CALCULATE (
SUM (nov_27[izdkol] ),
nov_27[datum_posnetka] = _max
)
,_result
,DESC
)
RETURN
IF( _rank <= 10, _result, BLANK() )
No need for the visual level filter:
You should be able to use the filter tab and unselecte the 'empty' values for the measure 'Top 10 kupcev'