topic Re: power bi in DAX Commands and Tips

power bi

rupak_12 — Thu, 23 Nov 2023 15:34:11 GMT

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

Re: power bi

Rupak_bi — Fri, 24 Nov 2023 19:28:18 GMT

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.

Re: power bi

Anonymous — Mon, 27 Nov 2023 07:50:15 GMT

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.

Re: power bi

Anonymous — Mon, 27 Nov 2023 07:47:43 GMT

Hi rupak_12 ,

Sorry for the extra screenshot, this one doesn't work so please ignore it!

Best Regards,
Dino Tao