Forum Discussion

Wolf01's avatar
Wolf01
Frequent Visitor
2 years ago

LOOKUPVALUE unexpected blank value

Hello, I need to determine person rank based on estimated full year performance. I tried to use an approach from this post but not fully working in my case Solved: Lookup closest value to a number - ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Wolf01 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Wolf01's avatar
Wolf01
Frequent Visitor
2 years ago

Hello amitchandak, thank you for your interest. Here is pbix file with anonymized data: 

https://drive.google.com/file/d/1_cdmb0eJVFodnWRFgjs0g0n5u_KHwoiW/view?usp=drive_link

 

I have several problems with the report. I created several pages where I try to demonstrate the problem.

 

Note: I want to show results just for people from ChosenPeople table. Therefore there is a „all pages“ filter with their IDs.

 

Page1:

  • Why there are not results for each row for Estimation of Rank Based on Full year performance measure?

Page 2:

  • Why there are not results for each row for lower range without var syntax measure and why are there more (duplicated) rows? I thought it is just lowerrange measure rewritten without var syntax.

Page 3:

  • There is measure Annual performance above/below limit which works fine. But if I use Annual performance above/below limit_v2 where i want to subtract 100%, duplicated rows for all IDs (ignoring report filter) appear. Why?

Page 4:

  • I want to use Result measure. Again, more people and duplicate rows appear.

 

I was able to solve problem from Page 1 by adding duplicate Limit tables somehow but I do not consider it as elegant solution. I have no idea what to do with the rest. I am afraid I am doing some kind of basic mistake 😊

 

Thank you very much for your time and help.