topic Re: Count of Items that make up a Percent. in DAX Commands and Tips

Count of Items that make up a Percent.

DustinD — Thu, 29 Jun 2023 18:17:17 GMT

i need some help with a dax messarue. so im fairly new to power bi if you could explain a bit in detail it would be greatly appreciated. so im stuck on a dax messure. below i have a snip of what my data looks like.

im trying to figure out how to make a table or card that will give a count of item numbers that make up a percent. for example i want a messure that gives a count of item numbers that make up 70% of the Cumulative column. so in this case it should return the number 5.

Re: Count of Items that make up a Percent.

some_bih — Fri, 30 Jun 2023 05:54:51 GMT

Hi DustinD check link by MattAllington

https://exceleratorbi.com.au/pareto-analysis-in-power-bi/

Hope this help

Re: Count of Items that make up a Percent.

DustinD — Fri, 30 Jun 2023 14:01:12 GMT

some_bih , so i was messing around and tried to get this to work but im unable to figure this out. dose anyone see what is wrong with the dax? if not it could be something outside dax.

Re: Count of Items that make up a Percent.

some_bih — Fri, 30 Jun 2023 14:23:31 GMT

Hi DustinD if you refering of reuse solution from link it seems that in solution filter is filtering Product table as shown below, while you are filtering Sales table. This could be reason for unwanted results.

FILTER(Products,[Cumulative %]<=0.8))

Re: Count of Items that make up a Percent.

DustinD — Fri, 30 Jun 2023 17:38:02 GMT

some_bih i will do some more messing around. i have alredy tried your soulutioin above. i also started digging into relationships.

Re: Count of Items that make up a Percent.

some_bih — Fri, 30 Jun 2023 18:04:24 GMT

Hi DustinD keep going! Wish you best