Return column value based on measure value power bi

[Chrisenthran]

Hello,

New to PBI and need help with the following problem; I hope my explanation is sufficient, please let me know if it isn't.

I have the following dimension table PctvsLevel with PctvsLevel[Percent] and PctvsLevel[Level] (The level allocated to each percentage level changes every so often so need not to hard code it in any solution)

0%	Level -3
1%	Level -4
2%	Level -5
3%	Level -6
4%	Level -7
5%	Level -8
6%	Level +2
7%	Level + 3

and a measure "Measure.Current %" that calculates the value based summed values on specific dates. 

I need a measure to return the [Level] where the PctvsLevel[Percent] = Measure.Current % in any given filter context. 

Thanks in advance

[v-xiaotang]

Hi @Chrisenthran 

Thanks for reaching out to us.

>> I need a measure to return the [Level] where the PctvsLevel[Percent] = Measure.Current % in any given filter context

Could you share some sample data and the measure code? and please give an example of the expected output, thanks!

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.