Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi Team.
Date | Category | Online offline | 1DaySales | Rank | percent rank |
4/6/2021 | Equity | Online | 123 | 4 | 100 |
4/6/2021 | Equity | Online | 345 | 3 | 75 |
4/6/2021 | Equity | offline | 567 | 2 | 50 |
4/6/2021 | Equity | online | 789 | 1 | 25 |
4/6/2021 | Commodity | online | 453 | 2 | 100 |
4/6/2021 | Commodity | offline | 564 | 1 | 50 |
4/6/2021 | Currency | online | 234 | 1 | 100 |
4/5/2021 | Equity | online | 256 | 3 | 75 |
4/5/2021 | Equity | online | 0 | 4 | 100 |
4/5/2021 | Equity | online | 345 | 2 | 50 |
4/5/2021 | Equity | offline | 754 | 1 | 25 |
4/5/2021 | Commodity | online | 683 | 1 | 100 |
4/5/2021 | Commodity | online | null | ||
4/5/2021 | Currency | online | 246 | 3 | 300 |
I want to calculate rank and percent rank
In report i have slicer Date, Category, Online offline
Ranking is based on 1daysales by the selection of date and category
percent rank forumula= ranking*100/counta(1daysales)
Note :- if its blank dont assign rank and percent rank also once i select online or offline category slicer, dont want seperate raking and percent rank , it should be same in both ways.
Solved! Go to Solution.
@Anshenterprices , Please find the attached file after signature. The last row is a bit different
Check the table in data view
@Anshenterprices , Please find the attached file after signature. The last row is a bit different
Check the table in data view
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.