Forum Discussion

mahsan_ojaghian's avatar
mahsan_ojaghian
Icon for Helper I rankHelper I
1 year ago
Solved

Create a dynamic sample table from main table based on slicer selection and append it back

How can I create a sample table from my main table in Power BI using the SAMPLE function, in such a way that I can later append this sample table back to the original table? The challenge I am facin...
DAX
Sample
sample table
  • v-hashadapu's avatar
    v-hashadapu
    1 year ago

    Hi mahsan_ojaghian , Thank you for reaching out to the Microsoft Fabric Community Forum.

     

    I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.

     

    Thank you for being part of the Microsoft Fabric Community!

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi mahsan_ojaghian , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.

  • mahsan_ojaghian's avatar
    mahsan_ojaghian
    Icon for Helper I rankHelper I
    1 year ago

    Hi,

    Thank you so much for your help on my question! I’m sorry for the late reply — I’ve been working through a few challenges implementing your solution and testing that the sample counts matched correctly, which took me some extra time.

    I really appreciate the time and effort you put into guiding me. Your explanation was very helpful, and I’m grateful you shared your knowledge.

    Thanks again!