Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All,
My data is in the below format -
I want show values and L2 region when I select a L3 region. But I want to display only those values that are in the top 10% of values (of the selected region). My dataset is quite large with 800K entries and there are a lot of entries whose values are quite small. So I want a user's focus only the big ticket values (i.e. top 10% of values).
Please help!
I tried the solution in https://community.powerbi.com/t5/Desktop/Top-N-percent-filter/td-p/682552 but it doesn't work for me.
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |