Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table with some of the columns as shown below
COMPANY NAME | REVENUE |
Company A | 56000 |
Company B | 78000 |
Company C | 122000 |
Company D | 367000 |
Company E | 104000 |
Company F | 450000 |
Company G | 34000 |
SO I want to develop a measure that will have the companies only with Revenue higher than 100,000. This will then be added to a visual table that should only contain the names of the companies and the Revenue higher than 100000. The catch is, the companies are around 1000 entries and there is a need to have an input filter where if I input 10, it ranks only the highest companies with a revenue of 100,000. Please assist. Thanks
Solved! Go to Solution.
Sumx(filter(summarize(Table, Table[Company], "_1", sum(Table[REVENUE])), [_1] > 100000), [_1])
Plot this with company Name
Sumx(filter(summarize(Table, Table[Company], "_1", sum(Table[REVENUE])), [_1] > 100000), [_1])
Plot this with company Name
Hey, It works perfectly however, what about a search input where I put 10 and it filters the top 10. is that possible?
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |