The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.