Forum Discussion
Biotech Deciling is Different - DAX HELP
Deciling Accounts by Sales in Biotech is a bit different than the typical n-tile type Deciling (breaking into 10 even groups), but is weighted based on the relative size of the Sales. The process...
Thank you both for taking the time to help!
Ultimately, I would love for this to be dynamic, meaning that I would be able to select different Time Periods and they decile would automatically update. In that case, would I be able to start with a calculated table as my VAR in the measure? Would I be able to do the sorting of a calculated table within a measure?
Hi,
My solution is completely dynamic.
For example, if I filter any of the AccountIDs out, the results aren't going to refresh based on the new subset of data.
Another example would be where I have a Time dimension and wanted to filter on different Time Periods.
Hi,
Please illustrate. My solution will work.