Count of Items that make up a Percent.

[DustinD]

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.

[DustinD]

@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.

[some_bih]

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))

[DustinD]

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

[some_bih]

Hi @DustinD keep going! Wish you best

[some_bih]

Hi @DustinD check link by @MattAllington 

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

Hope this help