I have a issue in power bi. Could anyone help me.
Suppose you have a table.
The table is hierarchy based and looks like Country then country name and then state name and then the city name and then the values like number of males , number of females, then ratio of of both. We have to find the top N state with ratio and number of males and number of females would come in others. and also it should be dynamic.