Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When I have this kind of data relationship:
Then I create a Top 2 measure based on Item group like this:
Top 2 Amount by item group = CALCULATE(SUM(Transactions[amount]), TOPN(2, 'Item groups', 'Item groups'[Group],ASC ), VALUES('Item groups'[Group]) )
Whereby what I want to show is the TOP 2 item group, what is the mistake, because currently still all item group come out.
The value and the ranking is correct though, only it doesn;t only show 2 of my item group.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.