Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX SAMPLE: how to refresh?

Hi folks,   looking for some help on getting a random sample to refresh. Client wants a visual that displays a random comment from customer feedback and associated data.    Goal: - small sample ...
Need Help
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

If you added an Index to your Comment table and used RANDBETWEEN to generate a number, which you then used to pick that Index from the Comment table, would that work?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the reply! I built a measure with RANDBETWEEN off the index of the comment. I'm trying to use the Card Browser visual which isn't letting me use the measure as a data field for the ID?

     

    Anyway to force refresh a sample in the table formula?

     

    Thank you!

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Hmm, not familiar with the Card Browser visual. I don't think that the standard Card visual has that limitation. Tables only refresh at load/refresh time while measures are calculated "on the fly" so I don't see a way to do it without using a measure.