Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    How about something like this:

     

    Random Quote = 
VAR Rand =
    RANDBETWEEN ( 1, MAX ( QUOTEBR[Index] ) )
RETURN
    CALCULATE ( MAX ( QUOTEBR[Quote] ), QUOTEBR[Index] = Rand )
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi benisanders ,

 

The measures works well on my side, could you share a sample pbix file if possible?

 

 

Regards,

Jimmy Tao