Forum Discussion
Max Tier Measure
Good morning, have a measure that I cant seem to figure out and need another set of eyes on. In the example below the goal is to only show the check box on the last record where the "Total Revenue MTD PW" value >= MTD Threshold. The MTD Threshold is a measure that basically taxes the minimum value from each rows and divides that by number of days in the current month. Then multiplies that result by number of days so far. I understand why my Projected Tier New measure is giving me the results that it is but all my attempts to return only the last value have not succeeded thus far. Any help would be greatly appreciated.
Projected Tier New =
var _Revenue = CALCULATE([Total Revenue MTD PW],DimServiceGroup[Revenue Group Flag] = "1")
RETURN
SWITCH(
TRUE(),
_Revenue >= [MTD Threshold], UNICHAR(10003),BLANK())
6 Replies
what do you mean by "last record" ? Sorted how?
The tiers table has a sort order column, so in this instance I would want to return the last tier name where Total Revenue MTD PW >= MTD Threshold. Given my example above the Total Revenue MTD PW = 8119 so it should return Preimer Pro. The sort order column is sorting the table by MTD Threshold low to high.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi lhall_csi,
Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful — this will benefit others in the community as well.
Best regards,
Prasanna Kumar
Hi lhall_csi,
We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.
If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution it helps others who might face a similar issue.
Warm regards,
Prasanna Kumar
Hi lhall_csi,
Just a gentle reminder has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.
This not only closes the loop on your query but also helps others in the community solve similar issues faster.
Thank you for your time and feedback!
Best,
Prasanna Kumar
