power bi

Hi rupak_12 ,

There are solutions to your first question:
My test data is as follows:

Adding an Index Column to Each Data Table in Power Query and use the following DAX to calculate the number of rows per row as a percentage of the total number of rows:

Percentage = 
'Table1'[Index] / CALCULATE(COUNT('Table1'[data1]),ALL('Table1'))

Use the following DAX to create a metric for each data table:

Measure1 = 
IF(
    MAX('Table1'[Percentage]) <= SELECTEDVALUE(MyColumn[Value]), "SHOW", "HIDE")

 Select the visual object and do the following in "Filters on this visual":

The same as the second visual object and the output is like below:

Then configure the slicer scope as follows:

The final results are as follows:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.