Forum Discussion

mahsan_ojaghian's avatar
mahsan_ojaghian
Helper 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!

FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

In Tabular, tables cannot change dinamically. Once SAMPLE has created the table, the table is that one and cannot change. If you explain what you want to do, we can try helping you finding another approach to reach your goals.

 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI