Forum Discussion
Dynamic Top N multi-row card through slicer
- Anonymous4 years ago
Hi YashPBI9154 ,
Provide a method for your reference.
Suppose we have a table like this.
Create a new calculated column.
Ranking = RANKX ( ALLSELECTED ( 'Table'[Country] ), CALCULATE ( [Count of customers], ALLEXCEPT ( 'Table', 'Table'[Country] ) ) )Then create a new table.
Table 2 = VALUES('Table'[Ranking])Enter data.
Relationships.
Note that the cross-filter detection between table 2 and table 3 should be set to both.
Attached PBIX file for reference.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi YashPBI9154 ,
Provide a method for your reference.
Suppose we have a table like this.
Create a new calculated column.
Ranking =
RANKX (
ALLSELECTED ( 'Table'[Country] ),
CALCULATE ( [Count of customers], ALLEXCEPT ( 'Table', 'Table'[Country] ) )
)
Then create a new table.
Table 2 = VALUES('Table'[Ranking])
Enter data.
Relationships.
Note that the cross-filter detection between table 2 and table 3 should be set to both.
Attached PBIX file for reference.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data