Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a table which is sorted in desc order by a basic DIVIDE measure in the column called '% Space in Backlog' (see below)
You can see that many of the '% Space in Backlog' are 100% but it does start to go down after that.
The RANKX I've done is as follows:
Solved! Go to Solution.
Hi @LOGiT,
You can try to use below measure if it suitable for your requirement:
Ranktest = RANKX(ALLSELECTED(V_POWERBI_DATASET),[T1CB divided by EstTreatCost],,DESC,Dense)
I create a table with some sample data to test.
SalPct = DIVIDE(SUM('Brand Rank'[Sales1]),SUM('Brand Rank'[Sales2])) CalPct = CALCULATE([SalPct]) RankTest = RANKX(ALLSELECTED('Brand Rank'),[CalPct],,DESC,Dense)
If above not help. it will be help if you share some sample data and [T1CB divided by EstTreatCost] measure formula for test.
Best Regards,
Jack Chen
Hi @LOGiT,
You can try to use below measure if it suitable for your requirement:
Ranktest = RANKX(ALLSELECTED(V_POWERBI_DATASET),[T1CB divided by EstTreatCost],,DESC,Dense)
I create a table with some sample data to test.
SalPct = DIVIDE(SUM('Brand Rank'[Sales1]),SUM('Brand Rank'[Sales2])) CalPct = CALCULATE([SalPct]) RankTest = RANKX(ALLSELECTED('Brand Rank'),[CalPct],,DESC,Dense)
If above not help. it will be help if you share some sample data and [T1CB divided by EstTreatCost] measure formula for test.
Best Regards,
Jack Chen
Hey @LOGiT ,
try RANKX(ALL(V_POWERBI_DATASET),CALCULATE([T1CB divided by EstTreatCost]))
If this is not working would you mind to share some sample data so that we can try it out by ourselves.
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |