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!

v-hashadapu's avatar
v-hashadapu
Community Support
1 year ago

Hi mahsan_ojaghian , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

mahsan_ojaghian's avatar
mahsan_ojaghian
Helper I
1 year ago

Thanks for checking in! My issue isn't resolved yet. I have a DAX Measure in Power BI to sample rows from a table based on a dynamic ratio from page filters. It should return 1 for sampled rows and after-warranty rows, and 0 for others. The sampling works, and I get the correct row indexes in SelectedIDs. But CONTAINSROW(SelectedIDs, _rowid) always returns FALSE when using _rowid = SELECTEDVALUE('Table'[RowID]), though it works with a fixed value like 123. I tried SUMX, but it slows down or breaks the visual due to large data. I need a way to compare each row's RowID with SelectedIDs row-by-row to return 1 for matches, without performance issues. Any ideas?