User Profile

darshaningale

Resolver II

Joined 5 years ago

82 Posts8 LikesLikes received10 Solutions

View All Badges

User Widgets

Contributions

Re: Rank based on category column
Lets assume the table has more columns such as "Type" where values are High , Critical , Low...And i want to select only High values while calculating the rank.
3 years ago Place Desktop
3.7KViews
0likes
1Comment
Re: Rank based on category column
You are a lifesaver. Thank you..What if I want to add some filters to this ??
3 years ago Place Desktop
3.7KViews
0likes
3Comments
Re: Rank based on category column
I have added sample data below. With your measure i am getting below rank in visual. I have added what is required in last column. Rank = RANKX(ALLEXCEPT(Sheet1,Sheet1[Category]),CALCULATE(SUM(Sheet1[Amount])),,DESC,Dense) Category SubCat Amount AAA AAA1 1 AAA AAA1 3 AAA AAA1 4 AAA AAA2 2 AAA AAA2 6 AAA AAA2 7 BBB BBB1 3 BBB BBB1 4 BBB BBB1 5 BBB BBB1 6 BBB BBB1 7 BBB BBB2 8 BBB BBB2 9 BBB BBB2 10 BBB BBB2 11 CCC CCC1 12 CCC CCC2 13 CCC CCC2 14 CCC CCC3 15 CCC CCC3 16
3 years ago Place Desktop
3.7KViews
0likes
5Comments
Re: Rank based on category column
For the data mentioned by you, the rank should be 1 for 100 , 2 for 30 ... Then again it should be 1 for 40 and 2 for 23. Then again it should be 1 for 93 and 2 for 80
3 years ago Place Desktop
3.7KViews
0likes
7Comments
Rank based on category column
I have three columns Category , subcategory and Amount column. I am adding category , subcategory and sum of amount column in table. I want to calculate rank (sum of amount column) based on only Category and should not change by addition of subcategory.
Solved
3 years ago Place Desktop
Need Help
3.7KViews
0likes
9Comments
Re: Plot date wise data on a line chart
I created another column based on the Month column. For month before june i used same number. For month after June i used the actual date. and put this column on X Axis.
3 years ago Place Desktop
533Views
0likes
0Comments
Plot date wise data on a line chart
I have Month on the X axis of a line chart and count on the Yaxis. I am using Date table to plot month on the X axis. The base data has dates in the table. Before June i want to plot months on the X axis. After June i want to plot dates on the same X axis. Please let me know how to perform this.
Solved
3 years ago Place Desktop
Need Help
583Views
0likes
2Comments
Re: Add a cumulative total in line graph
I have created seperate measures of each "Type" and also created one measure for Cumulative total and added all the measures in the line chart. Instead of using the "Type" in Legend section.
3 years ago Place Desktop
1.4KViews
0likes
0Comments
Re: Add a cumulative total in line graph

3 years ago Place Desktop
1.4KViews
0likes
2Comments
Re: Add a cumulative total in line graph
I also want to show count of each Type in the line graph. So there would be one line each for "High" ,"Medium", "Critical" , "Low" in addition to cumulative total.
3 years ago Place Desktop
1.4KViews
0likes
3Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.