cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Lookupvalue occasionally return blanks when randbetween used

In PowerBI Desktop I have a calculated column to rank a text value;

Rank = rankx(NYNY,NYNY[NHI],,ASC)

 

This returns unique values.

 

I have a calculated column to return a random value using rank to generate the lookupvalue 

 

Name1 = LOOKUPVALUE(NYNY[Surname&NHI],NYNY[Rank],randbetween(1,max(NYNY[Rank])))

 

Name 1 will randomly generate a blank value..Anyone see why??

 

NB the source table is a duplicate of another table with a fliter step added.

 

 

1 REPLY 1
Solution Sage
Solution Sage

Hi @sperry,

 

Without knowing your source table structure and some sample data. It is hard for us to understand your requirement.

 

Thereby, could you please share us more information like your source table structure and some sample data which can help us repro your issue. Also it will be more helpful if you can share us your desired result based on your sample data. It will give us the right direction.

 

Thanks,
Xi Jin.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors