Forum Discussion

Frequent Visitor

1 year ago

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 MT...

Super User

1 year ago

what do you mean by "last record" ? Sorted how?

lhall_csi
Frequent Visitor
1 year ago
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.
- lbendlin
  Super User
  1 year ago
  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