Forum Discussion
User defined bins that applies current filter context
Thank you for your answer!
I was going to upload sample data and expected outcome today but now I found a solution on my own.
As you answered, I realized that and that there were no dax-workaround to make a calculated column out of a measure.
The solution for me was to work out a way with a small separate table where I could put the user defined bins as a column (and then place it on category-level in a visual) and then work out the number of suppliers in each bins as a measure.
Pages like this helped me to build my solution:
https://radacad.com/dax-measure-in-the-axis-of-the-power-bi-report
"Then I create a calculated column where I put this measure"
As you have noticed - you cannot make a calculated column out of a measure. All your dynamic binning has to be entirely based on measures.
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.