Counting Pareto Items less than 80%

[Talal141218]

Hallo everyone, 

Please save my day. I am about to be crazy. 

I want to count the items less than 80% in pareto mesure and put in a card visual. The Formel as below : 

 IF(VALUE(Fact_SalesInvoiceLine[Parteto %]) <= 0.8, DISTINCTCOUNT(Dim_Item[ItemNo]))

when i use this formel count all items, which we have. 

Thanks in advance 

[Dangar332]

hi, @Talal141218 

here you use 

IF(VALUE(Fact_SalesInvoiceLine[Parteto %]) <= 0.8, DISTINCTCOUNT(Dim_Item[ItemNo])) 

logic in which you use two different table (Dim_Item and Fact_SalesInvoiceLine) so first check relationship bw them

you say it give when i use this formel count all items. if relationship is not correct then it might possible to give all item.

as you provide data screen short below formula work well. but it might other problem present like relationship or something else

[Talal141218]

Thanks for your reply. I traid this Formula before and didn't work correctly. I thnik as you in your reply mentioned the count all items despit there is a relationship between tabels. Do you have an idea, how can i check the relationship or correct it? 

[Dangar332]

hi, @Talal141218 

when you compare value with percantage it not work with 0.8 

for that you have to provide value which consider as a percantage value

try below
CALCULATE(DISTINCTCOUNT(Dim_Item[ItemNo]),Fact_SalesInvoiceLine[Pareto %] <= 80/100)

here you can check . i  have different data but it work perfectly

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

[Talal141218]

Thanks a lot for ur reply, but the Formula dosn't work either. I write down  the Pareto measure maybe helped in logic. As below : 

Parteto % =

Var Total = CALCULATE(Fact_SalesInvoiceLine[CM_SalesInvoiceLine_Amount_ExclAll_LCY], ALLSELECTED(Dim_Item[ItemNo])

)

var currt = Fact_SalesInvoiceLine[CM_SalesInvoiceLine_Amount_ExclAll_LCY]

var sumtable = SUMMARIZE(ALLSELECTED(Dim_Item[ItemNo]), Dim_Item[ItemNo], "sales", Fact_SalesInvoiceLine[CM_SalesInvoiceLine_Amount_ExclAll_LCY])

var cumulsum = SUMX(FILTER(sumtable, Fact_SalesInvoiceLine[CM_SalesInvoiceLine_Amount_ExclAll_LCY] >= currt ), Fact_SalesInvoiceLine[CM_SalesInvoiceLine_Amount_ExclAll_LCY])

return DIVIDE(cumulsum,Total)

[Dangar332]

hi, @Talal141218 
provide sample data and your expected output

[Talal141218]

Hi, 

I will send you a pic and the measure, which i used and already shared before. I want to count the Artikel the column in the left side less than 80% Pareto.

Thanks for your support. 

[NorbertG]

CALCULATE(DISTINCTCOUNT(Dim_Item[ItemNo]),Fact_SalesInvoiceLine[Pareto %] <= 0.8)

[Talal141218]

Thanks for your reply, but i tried this formula  and it dosen't work. 

[NorbertG]

How about:
CALCULATE(DISTINCTCOUNT(Dim_Item[ItemNo]),FILTER(Fact_SalesInvoiceLine[Pareto %] <= 0.8))

[Talal141218]

Sorry, the same problem, it will be better if we use conditional function.