Yes, I did. That will work only for how ever many rows there are for the data. So in the same superstore example It would give me more marks but not proportional amount. So if a row has $180 profit or something else has $300 in profit they both get one mark. Here it is without aggregate measures
Thank you for the idea
Yes we can! Sorry for taking a while to answer.
In order to achieve that you will need to use a technique called densification (Data Densification - An Intro?? ) and some table calculations to allow you to put one mark or each 1k of your metric (in this superstore case, Profit). Basically, you will need to write a custom SQL and pick a number that will represent the maximum number of bins that you will draw as an parameter in your query, then you will need to create a calculation that will bring a value for just the number of 1k's that you have.
I know this explanation is not so helpful, so I attached the workbook and I hope it will clarify what I meant.