Forum Discussion
power bi
Hi
Can anyone help me to solve prb in power bi.
1st part
I need to find the percentages like 10%,20%....100% of total row count of a table and the percentages should be shown in slicer so that when I click on 10% .... 100% in slicer it will give me the result 10% of total row count and here there are 4tables which should have 4 different slicer.
2nd part
After creating 4slicer and 4table which will work each individually then I need to find the common values between the 4 tables. For example - suppose when I select 10% in fst slicer 20% in second 30% in third and 40% in fourth I should have another table visual where it give me only the common values between the 4table of 10,20,30,40% so that I will get 4tables where I will get individual count according to the percentage and at the same time another table will be showing only the common values between the 4 table
Thanks
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.
3 Replies
- Rupak_bi
Super User
I dont know what data available in your tables, but the concept is to identify an index column or create a new one. then make a calculated column to to flag 10%, 20% ...... of the rows. thats it..
for common in the table, I need to understand what data inside.
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.Hi rupak_12 ,
Sorry for the extra screenshot, this one doesn't work so please ignore it!
Best Regards,
Dino Tao
