Forum Discussion
DAX Lookupvalue in same table based on measure
Hi, I have a simple table called QUOTEBR with two columns "Quote" and "INDEX." There are currently 4 values in this table as follows: | Quote | INDEX | | Q1 | 1 | | Q2 | 2...
How about something like this:
Random Quote = VAR Rand = RANDBETWEEN ( 1, MAX ( QUOTEBR[Index] ) ) RETURN CALCULATE ( MAX ( QUOTEBR[Quote] ), QUOTEBR[Index] = Rand )
Hi, I have posted a sample file here Google Drive. I have set up two sets of the measure one where i explicitly convert the RAND measure into an INT.
If when you open the file both of the Quote boxes work, then if you toggle between the options in the column1 filter to the left of the page you should get the issue.
One other odd thing i noticed while setting this up. it appears that even when the quotes do appear they do not seem to match the related quote in the table. as you can see in the below image the Rand2 measure returned the number 2, however the quote displayed is for 3. It seems like the measure is providing a different random number to the lookup measure than it is when it is displayed.